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.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
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.