Forum Discussion
conditional formatting with icon or colour that compare two columns in percentage changes?
Super UserPlease provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Dear lbendlin
Many thanks for your time on replying my questions.
i have uploaded the martrix dummy files here
https://we.tl/t-3IICMgypmi?src=dnl
my expected outcome is something like this(I think I need two measure? One is SHOP1 compare to shop 2, the other is shop 2 compare with shop 1 , and use it accordingly?)
- lbendlin
Thank you for providing the source data. Power BI doesn't know how to handle merged cells (your discount values). Please move the discount into the fact area. Ideally the data should be structured like this:
ItemID | Shop | DiscountRate | Value
Hi thanks for the reply
does that mean u suggest I transform the raw data cab into two table in follow arrangement .
ItemID | Shop 1| DiscountRate | Value
ItemID | Shop 2| DiscountRate | Value
and then there is a chance I have a way to compare them in a matrix visual?
again many thanks for pointing a way
