Forum Discussion
Matrix Layout and Heatmap
Hi nadeemrajabali ,
Select Values>Show on Rows (slider)>ON
refer :https://datasavvy.me/2017/08/10/you-can-now-put-values-on-rows-in-power-bi/
Best Regards
Lucien
Hi nadeemrajabali ,
In my opinion, you can create measure, measure is a reaction to the rules of the background color configuration, configure the specified month, the data reaches a certain value, set the rules of the background color. You can refer to the specific operation I replied to in this case below.
refer:https://community.powerbi.com/t5/Desktop/Conditional-formatting-3-text-options/td-p/2058800
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi nadeemrajabali ,
Could you pls share your pbix file? And I will test on it.Remember to remove confidential data.
Best Regards
Lucien
Hi Lucien,
Thanks for your help.
I am new so don't know how to attached files. Below is the link to folder to get PBIX and Excel file I have used. I have removed the data and modified main information due to confidentiality,
https://drive.google.com/file/d/1BGdzioxKEUJwWQOtz1Cb20U11xu4j3xl/view?usp=sharing
The conditional formating is applied on whole table however I have to use it on Row, also the column header I only months to dispaly and Three pricing to apear on the Row level infront of Product.
Thanks
Nads
Hi nadeemrajabali ,
When I click the link, it show me:You need access rights.
Could you pls share it on a public link?
Best Regards
Lucien
v-luwang-msft try this link, wont be a issue or is there a email I can send you file to?
https://drive.google.com/drive/folders/1qhHwDe1kfrkyv5Buy2UbcZnc4RRqhI6C?usp=sharing