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

[mjanecek]

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.

Mark Janecek 

Business Intelligence Analyst

Amwins Insurance Group

[technolog · Accepted solution]

@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

  

[mjanecek]

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

[Pragati11]

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]

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.

Mark Janecek

Business Intelligence Analyst

Amwins Insurance Group

[Pragati11]

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:

[mjanecek]

Pragati:  When I try to select a measure, nothing shows in the drop down.

This is exactly what I see when I try to select a measure.

I see that there is no red highlight in your video on the drop down box.  I updated my version of PBI Desktop, restarted and checked Options and settings for anything that may have been off, and I still can't select a measure here.

MJ

[Pragati11]

Hi @mjanecek ,

I do see a RED highlight on the formatting option on my side. It remains red until I select anything from the dropdown. Not sure what is happening at your end. Can you try re-creating your visual and test this?

If still issue can you share your power bi file removing any sensitive information from it?

You can share using Dropbox or WeTransfor.