Forum Discussion
Solved
"Advanced" Filtering data in a report
I have a large amount of similarly formated data that I need to be able to filter out per request while displaying a report (so not in Power Query). The data is related to power plants, many of them....
Hi daxyco ,
This is my test table1:
Test table2:
Transform table2 in Power Query. Select Date column - Transform tab - Unpivot other columns.
You will get a table like this, close and apply to Power BI:
Create one to many relationship between two test tables:
Create some slicers from table2 and create a card visual from table1:
You can filter report by any of these properties:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's exactly what I needed, thanks! The visual I posted was from another table, that's why there was a difference for each year.