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.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Regretfully this had the same effect as my formula, i.e. it formatted all bars as though they were the max.  I thought possibly it was because I had the count of user id displayed "show values as percent of total" but when I returned to "no calculation" (just showing the counts and not the percent) the same result.  However pankajnamekar25 response did work.  I'm sure it's something I'm doing, so hopefully I'll get better at this.  Thank you.