Forum Discussion

kiranshetty_11's avatar
kiranshetty_11
Frequent Visitor
5 years ago
Solved

Table does not allow to update conditional formatting

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 i...
General Comment
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    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

Pragati11's avatar
Pragati11
Super User
5 years ago

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's avatar
kiranshetty_11
Frequent Visitor
5 years ago

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.

    • kiranshetty_11's avatar
      kiranshetty_11
      Frequent Visitor
      5 years ago

      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's avatar
        v-lili6-msft
        Community Support
        5 years ago

        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