This week's climb up Mount DAX meant getting cozy with #HASONEVALUE #SELECTEDVALUE #ISFILTERED #ALLSELECTED #FILTER and #COUNTROWS. Many thanks to Andrey Nikolov and his post on Slack Exchange about conditional formatting, as well as the youtube video from @Bielite on dynamically selecting variables. The side by side Tablea vs. PBI version below shows that the results ended up pretty close. I have put conditional labels on my Power BI wish list. I am thrilled tho about the built in spell checking in PBI and really like the way the slicers looked horizontally and vertically.
