Forum Discussion
Setting Dual Y-Axis on Line Chart with Multi-Select Parameter
Hi Experts,
I'm currently working on a line chart that utilizes a parameter with multiple measures:
- Total Sales
- Total QTY
- Total Profit
- Total Discount
When selecting multiple parameters, such as Total Sales and Total Discount, I encounter an issue where the Total Discount values, being significantly lower, are not distinctly visible and are displayed as "0K" on the data labels.
To address this, I attempted to implement a dual Y-axis specifically for Total Discount.
However, this led to the line charts being duplicated instead of just adding a second Y-axis for the Total Discount.
Could anyone provide guidance on how to correctly set up a dual Y-axis for Total Discount in this scenario without duplicating the line charts?
Attached is my PBIX
Parameter Line Chart - Dual Axis .pbix
Thank you!
- Anonymous2 years ago
Hi puru85 ,
Try formatting [Total Discount] separately like this:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
1 Reply
- AnonymousNot applicable
Hi puru85 ,
Try formatting [Total Discount] separately like this:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group