powerbistackedcolumn

Power BI Sorting stacked columns


I have seen this answered in posts from a few years ago but the interface has changed since and I can't figure it out.

I have a list if items within several processes that have "high", "medium", and "low" ratings. I need to create a stacked column chart with this information, and it would be easiest to read if "high" were at the top of the stack and "low" were at the bottom. Currently, however, the order from top to bottom defaults to "medium" at the top, "low" in the middle, and "high" at the bottom. is there a way to reorganize this in the 2024 version of Power BI?

enter image description here


Solution

  • you can create a dim table. click the rating column and sort by sort column

    enter image description here

    you link this table to your fact table and when you display the visual use the rating column from the new table.

    enter image description here