Conditional formatting, no value to select

[MrNeverland]

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 highlighted in red. I have never had this issue before and think it might be related to the calculated table. However, it doesn't make any sense. Can anyone help me with this? I deleted the table, but the problem persists, so there must be another issue.

Here is the DAX code for the table:

InterpolatedData = 
VAR ProjectTable = FILTER(
    'GetHglDchExportData',
    NOT(ISBLANK([ConstructionStart])) &&
    NOT(ISBLANK([ConstructionEnd])) &&
    NOT([State] IN {"ungesichert", "ab 2 Jahre Garantie", "ab 5 Jahre Garantie", "Absagen"})
)
RETURN
    GENERATE(
        ProjectTable,
        VAR StartDate = [ConstructionStart]
        VAR EndDate = [ConstructionEnd]
        VAR VolumePerDay = [DailyOrderVolume]
        VAR ProjectId = [ProjectId]
        VAR Descriptio = [Description]
        RETURN
            SELECTCOLUMNS(
                CALENDAR(StartDate, EndDate),
                "Datum_daily", [Date],
                "Volume_daily", VolumePerDay
            )
    )

Thank you in advance for your help!

[Ritaf1983]

Hi @MrNeverland 

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.

[MrNeverland]

@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.