Forum Discussion
Conditional formatting for multiple columns with text values and numbers
Hello everyone. I'm quite new in Power Bi and trying to get one type of formatting working. I have a table with 10K+ rows and around 30+ columns. Most of the columns are week of the year, but in...
Your week columns should be unpivoted in your query, and you should add a Date table to your model (if not already). You can then use the week column from your Date table, and this would let you apply conditional formatting (SEARCH for "R") to the measure that would go in the values area (as well as more easily do your other analyses). The matrix would give you your row/column/grand totals.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat