Forum Discussion
conditional formatting with icon or colour that compare two columns in percentage changes?
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?)
Super UserThank 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
- lbendlin
Don't do separate tables. This should be all in one table.
ItemID Shop Discount Value 12 Shop1 78 444352 12 Shop2 78 346760 12 Shop1 80 20 12 Shop2 80 20 etc.
My raw csv file comes in like this:
ItemID Shop1 Shop2 Discount
12 10000 12000 78 12 9000 8000 78 10 80 109 80 9 900 100 90 so far and so on.
what is the best solution or direction I should look into? Thanks