Forum Discussion
Super UserBest practices for sorting/conditional formatting bar or line charts with legends
Hello,
like in a topic, looking for best practices for community users in order to add conditional formatting for bar charts /line charts with legends?
Accordingly to this topic:
https://community.fabric.microsoft.com/t5/Desktop/How-to-add-conditional-color-formatting-for-clustered-bar-chart/m-p/4853247#M1441153
there is no option right now to do this.
What are your workarounds for it? Best practices?
What if your boss sees all those ugly theme colors shown in a bar chart with legend?
Best,
Jacek
7 Replies
v-ssriganeshCommunity Support
Hello jaryszek,
Thank you for your query. We recommend raising an idea in the Ideas forum (Fabric Ideas - Microsoft Fabric Community). If it receives more upvotes, the Microsoft team will review and consider implementing it in future updates.
Thank you,
Ganesh Singamshetty.- jaryszek
Hello,
this post is not about idea.
This is about best practices from power bidevelopers. How they are handlind the issue?
Best,
Jacek- v-ssriganesh
Hello jaryszek,
Thank you for the clarification. Since native conditional formatting for bar or line charts with legends isn’t currently supported in Power BI, which is why I suggested the Ideas forum as a way to propose this feature for future consideration. Many Power BI developers rely on manual color assignments in the Data colors pane to ensure visually appealing and consistent charts. They often use custom color palettes for a professional look and test accessibility with the color-blind preview. For dynamic needs, some developers use custom visuals like Deneb or Charticulator from AppSource, which allow more control over colors based on data fields. Sorting is typically managed with built-in options or custom DAX measures like RANKX for flexibility.Thank you,
Ganesh Singamshetty
- v-ssriganesh
Hi jaryszek, Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum, we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.
- jaryszek
Setting up colors manually is a disaster...
Imagine that new categories in the next month will entirely change...it means that you lose all your colors and power bi use those theme ones because color is assigned to category, not to the highest value.
Best,
Jacek- v-ssriganesh
Hello jaryszek,
You're right manual color assignment breaks when categories change, as colors are tied to category names, not values or logic. This is a well-known limitation in Power BI.
Since there is no reliable native workaround for dynamic conditional formatting in charts with legends, As I have suggested earlier, please raise a new idea in the Fabric Ideas forum. With enough upvotes, the Microsoft team will review and consider implementing it in future updates.
Best Regards,
Ganesh Singamshetty.
