Forum Discussion

mtdewrocks's avatar
mtdewrocks
Regular Visitor
2 years ago
Solved

Use Parameter value to conditionally format bar chart

How can I use the parameter value to conditionally format a bar chart? I am able to use the following formula to color the bar chart in the way I want -  Color = if('Raw Player Stats'[PTS]>10, 1, 0...
  • Ritaf1983's avatar
    2 years ago

    Hi mtdewrocks 

    You can use a numeric parameter for the desired result.

    1. Add parameter 

    2. create a flag measure with the needed condition  (using the parameter measure that you will have after creating the parameter):

    color flag = if('Parameter'[Parameter Value]=[count_companies],1,0)

    3. use conditional formatting based on the flag measure

    Result :

    Pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly