Forum Discussion
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...
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.
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. 😁