Table does not allow to update conditional formatting

[kiranshetty_11]

I had added a conditional formating on a table through a measure which I modified which no longer was elligible for the visual. The visual doesnt allow me to remove the conditional formatting since its no longer recognized as a table (conditional formatting options is no longer visible in 'Format' tab)

Only option for the user here is to recreate the table and add a new conditional formatting as desired.

[Pragati11]

Hi @kiranshetty_11 ,

Can you add a screesnhot on your problem please? This doesn't help much.

Thanks,

Pragati

[kiranshetty_11]

Basically, in the 'Table' visual you can no longer see  'Conditional formatting' option due to an error in the conditional formatting (measure) I had put on the field through a measure. Hope this helps clarify my problem

[Pragati11]

Hi @kiranshetty_11 ,

Can you delete this measure of your's which is giving error and check?

I can't reproduce this error at my end. Can you share your pbix file by removing any sensitive information?

Thanks,

Pragati

[kiranshetty_11]

I need both measures in my model so I have no option but to recreate the table with a new measure altogether.

Below are the 2 measure I have used for formatting: 

1) . Card Formatting

Color_code = SWITCH(

TRUE(),

VALUES('Table'[Trainings]) <> "abc", "#E9E4E2",

[abc % complete] >= 0.945,

"#88cc00", AND( [abc % complete] >= 0.895, [abc% complete] < 0.945 ),

"#FFFF00", AND( [abc % complete] >= 0.745, [abc % complete] < 0.895 ),

"#FFBF00", "#FF0000"

)

2). Table formatting

Color_code = SWITCH(

TRUE(),

[abc % complete] >= 0.945,

"#88cc00", AND( [abc % complete] >= 0.895, [abc% complete] < 0.945 ),

"#FFFF00", AND( [abc % complete] >= 0.745, [abc % complete] < 0.895 ),

"#FFBF00", "#FF0000"

)

In measure 1 I have to add values function since I need the card to reflect formatting only if the value is selected. This measure cannot be used in the 'Table' visual since it gives the below error:

Error Message:
MdxScript(Model) (83, 5) Calculation error in measure 'Data'[Overall Color_code]: A table of multiple values was supplied where a single value was expected.

Hope this clarifies.

[v-lili6-msft]

hi @kiranshetty_11 

first, for table visual, conditional format is here:

right-click field which you want to do conditional format

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

second, do not use VALUES in the measure, just please use MAX/MIN instead.

Regards,

Lin

[kiranshetty_11]

Thanks for looking into this issue however CF is not available in the 'Fields' tab as well.

Also I am using values function since its a text. Not sure Min/Max would work on this case? 

[v-lili6-msft · Accepted solution]

hi  @kiranshetty_11 

Min/Max should work, you could try it, and if you still have problem, please share your sample pbix file for us have a test, that will be a great help.

Regards,

Lin