Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Color for Max on Bar Chart formula not working

I'm new to power bi and I'm trying to color the min and max column in my bar chart differently from the rest of the bar chart columns.  I've looked at different options online.  None of the formulas ...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello Anonymous 

     

    Here you can go

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Ashish_Excel pankajnamekar25 for the prompt response.

I have created sample pbix file by using sample data to replicate the scenario.

You can find the attached .pbix file for your reference.

After creating chart , Apply Conditional Formatting

Select the chart.

In the Visualizations > Format pane, expand Columns > Colors.

Set:

Format by: Field value

Based on field: BarColor measure

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.