Forum Discussion
shakirkhanani
6 years agoHelper I
Color Code Based on Column
The two columns belongs to the same table: 1. Web Order 2. Web Order Shipment No. (shipment number can be more than 1, due to bigger order) is there any way to colour code (for example) them to qu...
- 6 years ago
Hi shakirkhanani ,
There is a way to solve your question.As you can see, I create a measure, which is used to distinguish and mark my dataDistinguish and mark my data. This step is very import.
Here is my measure:
Measure 2 = CALCULATE( SUM([Sale 2013]), ALLEXCEPT( Sales, Sales[Brand] ) )And here's related articel:
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
shakirkhanani
6 years agoHelper I
Awesome! worked like a charm... Thank you so much.