Best practices for sorting/conditional formatting bar or line charts with legends

[jaryszek]

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-cluste...

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

[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,

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.

[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]

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

[jaryszek]

thank you. 

Best,
Jacek