Forum

Notifications
Clear all

Get filtered data with index and match

3 Posts
2 Users
0 Reactions
95 Views
(@cucharon)
Posts: 29
Trusted Member
Topic starter
 

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

 
Posted : 11/09/2022 1:18 pm
Riny van Eekelen
(@riny)
Posts: 1210
Member Moderator
 

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

 
Posted : 12/09/2022 3:19 am
(@cucharon)
Posts: 29
Trusted Member
Topic starter
 

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

 
Posted : 12/09/2022 4:08 pm
Share: