Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Conditional formatting, no value to select

Hey everybody,   I have an issue with conditional formatting. Before I created the table in the code, it worked fine. Now, I cannot select a value for the rules, and the selecting box it is highlig...
Need Help
Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Anonymous 

Conditional Formatting is available when the column specified with any aggregate function or it's a measure. In your scenario, you can set one aggregate function for the Amount column, eg: Sum. Then you can see the Conditional Formatting is available.

For more specific assistance :

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Ritaf1983 thanks for your reply - true, here are the two files WeTransfer (I didn't find any way to insert the files in the post.)

    - PowerBI dummy

    - Exceldata dummy

     

    A further problem is, I cannot choose a visual and then drag & drop the data from GetHglDchExportData and the other calculated table. I always have to select firstly the value and then change the visual. Super annoying. And there are some more of these problems. I have the feeling that the tables and data is corrupted. I even tried copying the powerbi and start over. same problem here. It might be the calculated columns in GetHglDchExportData? But I never had this issue before.

     

    Hope the data helps.