Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have values for multiple brands, and I want to display all values on line chart with my own brand shown as zero line, and other brands as difference. How to display values from my brand as zero line?
I understand that you don't only want 0 line but the other lines should be the difference between the their brand and your brand
Please use this
Imagine that you are Central here so we can make use of above calculation to make your brand 0 and other lines are just the diff with the Central sales
@Tokkerashid For constant line (own brand) you can either refer my below reply OR check the Analytics Pane like below:
@Tokkerashid Refer the below screen shot:
But I have a lots of brands and can't add them as separate values.
I want to create a measure where values for my own brand is on zero line (even they are not zeros) and other brand's values as differences
You can create a measure and add it to the Values section of the line chart
Own Brand Zero = 0
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |