Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Conditional formatting not working as expected

I have a report which is a .pbit (connects to ADO data) - when a user loads the report they have a particular page that has a table visual which has conditional formatting. When the report first loads it looks like so, which is incorrect as all rows should be green:

 

 

When I change the date (but not the other two slicers) it updates:

 

 

The table being used is called 'Weeks' which is created via:

 

Weeks = GENERATESERIES(1,16,1)

 

 

The column is:

 

Future = TODAY()+Weeks[WeeksMultipliedBy7]

 

 

With a measure of:

 

WeeksMultipliedBy7 = SUMX(Weeks, Weeks[Weeks] * 7)

 

 

How can I get it so that upon report load the table conditional formatting shows correctly?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous,

    Current power bi desktop support to create dynamic calculated column/table based on filter effects. They do not work on the same level, and you can't use the child level to affect their parents.
    For measure expressions, they can dynamic calculated based on current row and filter contents, but their result will be fixed to static values if you invoke them in calculated columns.

    Row Context and Filter Context in DAX - SQLBI

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng