Hello,
I would appreciate it if someone could help me with this question. I've created a very simple example to explain it.
I have raw data that comes from a database tool. The colums are not organized as desired so, I want to organized them in other tab and, in addition, I want slices to filter that the information.
Tab raw data:
- I copy paste the information of my database tool in a table (with format table so that I can add slicers).
Tab Dashboard:
- With Index and Match, I can get the information with the columns ordered as desired.
- I paste the slices above this information.
When I filter the data with the slicers, the data filtered is that of the raw data tab, not the data in the tab dashboard.
Is there any way that I only get the data that is not hidden?
Thanks in advance,
Cristina
Hi Christina,
I would suggest you use PowerQeury to transform your raw data. Load the result to the Dashboard and create the slicers off that table. Please see attached.
Riny
Hello Riny,
It didn't occur to me to do it this way. It works perfect.
Thanks so much for your quick response and kind support.
Have a nice Sunday!!!
Cristina