Forum Discussion
Donny620
Helper I
Helper IPBI Matrix with sub columns - how to have conditional formatting per column?
Hi! I have the data files but don't know how to upload them. I have data that looks like this where each row is a unit (# 1 - 3) , when it left inventory and how long it was in inventory, and ...
lbendlin
Super User
Super UserYou can create a separate measure that computes the formatting per "column".
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Donny620Thanks so much for the link. I can't seem to figure out the 'formatting per column'.
Here are both files:
https://drive.google.com/file/d/1sD2fv5i_eIE712X9_MbGUtZPC7HKbXM5/view?usp=sharing
Note: the data is on the data tab of the Excel. In the real data I will have a calculated column which converts and groups date to YYQ.