Forum Discussion
PChmurzynski
2 years agoFrequent Visitor
Omitting nulls/blanks in a Conditional Formatting Measure
I have a table visual with a a Date/Time Column which has some null values. I've effectively applied conditional formatting to that visual by utilising a switch measure. The problem is I'm getting "e...
- 2 years ago
I have solved it. It's very emberrassing. The problem was I was refferring to a different column in the measure than I wanted to apply the conditional formatting to. Bothe measures in the question will work just fine as long as we change the column name. The correct Measure looks like this:
DateStatus = VAR TodayDate = TODAY() VAR ApptDate = MAX('factPropertiesRemAppts'[RemJobdtmAppt]) RETURN SWITCH( TRUE(), ISBLANK(ApptDate), BLANK(), -- Leave blank if there is no date ApptDate > TodayDate, "Green", ApptDate = TodayDate, "Yellow", ApptDate < TodayDate, "Red" )
PChmurzynski
2 years agoFrequent Visitor
I did, but with not effect
- ray_aramburo2 years agoSuper User
Is it possible for you to share the .pbix file removing any sensible information?
- PChmurzynski2 years agoFrequent Visitor
When i drag and drop it tells me the file type (.pbix) is not supported. Any other way I can upload a file here?
- ray_aramburo2 years agoSuper User
Try sending me a DM and there I can provide you an e-mail 🙂