Forum Discussion

mjanecek's avatar
mjanecek
Helper I
3 years ago
Solved

Issue Using a Measure as Field Value Format Style for Column Chart

I have created the below measure to set a color for the bar on the combo chart to one color and the remainder of the bars to another color, according to the current monthly value of the "SRU Avg Premium No $0 Transactions" Measure.

 

Premium Colored =
var maxprem = MAXX(ALLSELECTED('Calendar'[Accounting Month]),[SRU Avg Premium No $0 Transactions])
var curprem = [SRU Avg Premium No $0 Transactions]
var result = if(curprem = maxprem,"#215479","#CCCCCC")
RETURN result
 
When I try to apply the measure to the format style of the combo chart, as a Field Value, the drop down to select the field to base the format on is colored red and won't allow me to select any of my measures.
 

I am running the Dec 2022 version of PBI Desktop, so that is not the issue.

 
 
Need Help
  • technolog's avatar
    technolog
    2 years ago

    mjanecek I have similar problem.

    You can fix it in 3 steps:

    1. Set one color in the measure without any conditions

    2. Set this measure for visualization
    3. Set the right condition in the measure to calculate the color

     

    p.s. Setting the measure type as "Text" has helped in the past, but that no longer works for me now

      

7 Replies

  • mjanecek's avatar
    mjanecek
    Helper I
    3 years ago

    I was able to solve this issue by changing the data type of the measure from whole number to Text.

  • technolog's avatar
    technolog
    Super User
    2 years ago

    mjanecek I have similar problem.

    You can fix it in 3 steps:

    1. Set one color in the measure without any conditions

    2. Set this measure for visualization
    3. Set the right condition in the measure to calculate the color

     

    p.s. Setting the measure type as "Text" has helped in the past, but that no longer works for me now

      

  • Pragati11's avatar
    Pragati11
    Super User
    3 years ago

    Hi mjanecek ,

     

    Can you please elaborate on what option are you using to apply this condition formatting using measure on your chart?

    Are you using the same option as shown in the screenshot below:

    I am able to use measures here, so wanted to understand what option you are using.

     

    • mjanecek's avatar
      mjanecek
      Helper I
      3 years ago

      Hi Pragati: That is exactly the option I'm trying to use.

       

       

       

      When I select "Field Value" the drop down to chose a filed is colored red on the boarder and will not allow me to select a measure from my model.

       

       

       

      I can find the measures in the model, but when I try to pick one, it does not show as selected in the drop down.

       

       

       

       

      • Pragati11's avatar
        Pragati11
        Super User
        3 years ago

        HI mjanecek ,

         

        Can you try selecting the measure after searching for it please?

        I checked at my end and it works perfectly fine. I don't seem to see any issue in there. You see the red higlight on the what field should be base on? area, but it works when you select the searched measure.

        See the small video attached below: