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
nadeemrajabali So, in your matrix you would put Item Number, Item Description and PO Currency into your Rows field well. Put Month into your Columns field well and whatever Values you want. Then you would go into the Format sub-pane of the Visualizations pane and expand Row headers. Scroll down and toggle off Stepped layout. Then go back to the Fields sub-pane of your Visualizations pane. In the Values field well, click the drop down arrow for whatever column you have and choose Conditional formatting and Background color.
Thanks Greg, Unfortunately I am unable to acheive what I am looking for. I guess I have to change my data layout in the query editor. However will wait for some more feedbacks.
Sorru Greg I realised that I didn't tag you 🙂
