Forum Discussion
Data set not updating date conditions
Greetings,
I am creating a dashboard that includes dates in addition to a geo plot of a location for an event. Ideally, I would like any dates that have passed to turn red, while future dates remain green. I am able to get the conditions to work when I create the report, however the conditions do no update once the report is saved, I've tried refreshing both the database and report. I am using the Cloud version of Power BI.
Conditional format for dates (accurate when created)Conditional format of plots
Not correct to use calaculated columns from excel into Power BI and expect the refresh to goes well.
Use DAX to replicate your formula into Power BI. You can also use conditional formatiing on the data column like
6 Replies
The condition for the geo is under the Bubbles > color > Default conditional format.
In the conditional formatting, I am using Gradient based off a column in an excel file.
- To keep it short, in the excel file there is a column, that will put a 1 or 0 based on the date being after the current date. I've confirmed the excel formula is working correctly, shows all past dates as a 1. I can post a pic if needed, just have to go between two computers to do so.
- aj1973
Community Champion
I see,
The formula you applied in Excel won't be applied in Power BI. It is better to remove all calculated columns from Excel and use DAX in Power BI to replicate them.
