Forum Discussion
"Advanced" Filtering data in a report
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.
Community SupportHi 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.
v-yadongf-msft seems to be working, thanks! I know I might be asking for too much now, but is it possible to somehow keep this type of view in stacked column chart visual? This way I can already see how much each type of plant contributes to total generation, but without having their generation in separate columns, I can't see a way of creating this kind of a visual. I guess I could create two separate queries, one being unpivoted as you mentioned, one pivoted (as the original data) and have two separate visuals for each of them, but I'm guessing the people looking at the report would like to see as much detail in one chart instead of having to look at two different charts.