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
I have created a stacked bar chart. Each bar has 5 stackes, which created by a measure.
The requirement is to sort the chart by sum of two stack values.
Since the chart is built on measure i am not able t select them via "Sort by column".
Please suggest an work around.
Note: we can create the stakes by using one column in Legend field. however the value will be then a measure (SUM). I have splited the stack for sorting purpose and it works well when i am sorting by one stack. however the requirement demads adding up to stack valuse for sorting.
Regards
Jose
Looking for this functionality as well, did you post an idea for this Jose?
Hi @Jose1947NK12333,
Currently, it is not supported to sort chart by total value of two measures. We are able to sort chart based on any column or measure that has been added into this chart. In other words, if you want to add up two stack values for sorting, you might have to create a third measure and add this measure into chart.
Personally, I would suggest you submit this idea at this page as a feature request, if it is mentioned by many users, our product team will consider adding it to future release. Thanks for your understanding.
Regards,
Yuliana Gu
Hi
I have created a stacked bar chart. Each bar has 5 stacks. The requiremnt is to sort the chart by sum of 2 stack values.
Note: I have created 5 measures and used them as stacks. So "Sort by Column" would not work.
please suggest.
Regards
Jose
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |