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 region contains several cities)

- the visual in question is a histogram that displays all the cities of the country.

- my question is how to make conditional formatting only for the cities belonging to the region selected by the slicer.

Thanks in advance

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.

2 Replies

  • 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

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