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.
Hi Guys,
I keep running into the situation in which I have a slicer but it doesnt show the categories only the exact numbers not sure what to do. I have added Net Revenue, Gross Revenue & Cost on the slicer but doesnt come up with the correct categories just numbers.
Below is a photo If someone could assist me.
Solved! Go to Solution.
Hi @ttriber ,
If you need to appear categories, you need to unpivot these two in PQ to get a column of numbers and a column of attributes. Attribute column to distinguish Net Revenue from Gross Revenue.
Let's say it's your current situation.
Go to the Power Query Editor, select the two fields, and click "Unpivot Columns".
Then click "Close&Apply" and go back to Power BI Desktop, put two new fields into slicer, you'll get this.
Unpivot columns - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ttriber ,
If you need to appear categories, you need to unpivot these two in PQ to get a column of numbers and a column of attributes. Attribute column to distinguish Net Revenue from Gross Revenue.
Let's say it's your current situation.
Go to the Power Query Editor, select the two fields, and click "Unpivot Columns".
Then click "Close&Apply" and go back to Power BI Desktop, put two new fields into slicer, you'll get this.
Unpivot columns - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I am not familiar with what your saying could you give me better instructions. I have tried changing it to a visual filter on the main visual but nothing has changed.
Take "revenue type" column(if you have) in any other related table, sothat ypou will get, otherwise apply visual level filter on the main visual.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |