Forum Discussion

Saidi's avatar
Saidi
New Member
4 years ago
Solved

conditional formatting histogram bar chart

I come to you for technical support if possible. I would like to do conditional formatting on a histogram visual (Bar chart) - I have a slicer that displays the list of regions in the country (each ...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, Saidi 

     

    Create a calculated table(Slicer) summarizing regions and cities, then create a slicer using the summarized region field instead of the region field of the main table.
    Then create a measure as follows:

     

    _color = 
var _condition=IF(MAX('Table'[Value])>5,"Green","pink")

var _isSelected=MAX('Table'[City]) in SUMMARIZE(ALLSELECTED('Slicer'),[City])

var _notSelected="#E6E6E6"

var _if=IF(_isSelected,_condition,_notSelected)
return _if

     

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

Saidi , For that region need to be independent slicer , measure not joined to the table

 

Then you need to create a measure and use that in conditional formatting using field value option

 

Switch( True() ,

max(region[region]) in allselected(slicer[region]) , "green" else "red")

 

refer, if needed

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4