Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formatting on Items with no Data

I'm currently trying to insert icons into a table visual based on a specific status fields (Green, Yellow, Red). The underlying data is setup such that there's a parent table, a relationship table an...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

I'd have to see more of what you are referering to via an image to more fully understand, but on the face of it, if there is no data, there is nothing to conditionally format, right? Maybe you should replace blanks with a space or zero, then apply conditional formats accordingly?

=COALESCE(ISBLANK([MyField]), " ")

That will return a space where there are blanks. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the quick replay, in trying to mock up a sample for you, I've come to realize I think my entire understanding of Show Items with no Data is flawed. I'll need to redo this report, as I was trying avoid flattening the data too much with Merge operations, but I think since I want this Outer join I'll have to do it that way.

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    There are valid uses for "show items with no data" but it can be over used. Nothing is a substitute for a well thought out model through some good transformations. I've tried to take shortcuts too many times myself.

     

    I'd say I spend 60-85% of my time in Power Query getting a good model ready. 

     

    Then I spend the other 80% of my time in DAX. 😁