Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
in my Power BI matrix Ihave as column "period" and as values 1) food and 2 ) drinks .
I see alway both values ( food and drinks) per period, but i want to see first all periods for food and then all periods for drinks
it should look like this in Power BI :
is this possible ?
the table looks like this :
@Sonne , Not very clear. If you take period on the row it should be like that?
if I take period into rows I m getting this view :
this is not what I want.
i want per person first food from P08-P12, than drinks from P08-P12
in excel in the pivot i can change the order of values :
Hi @Sonne ,
What does the original data table look like?Please show with screenshots or paste table data.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello , this is the excel table inserted into power BI. I can not change the format as this file is coming from a tool :
Hi @Sonne ,
Based on the data you provide, food and drinks are at the same level and cannot be drilled to meet your needs. You need to use bookmarks to solve this problem.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |