Forum Discussion

puru85's avatar
puru85
Helper II
2 years ago
Solved

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!

 

1 Reply