Forum Discussion

eliasayyy's avatar
eliasayyy
Memorable Member
8 months ago
Solved

How to create a dynamic Measure/Function to dynamically scale line and bar charts

Hello Everyone!   I am doing data analytics for marketing campaign.   I want to display on my line chart multiple measures based on Field parameter measure selected. some examples of measures.  ...
Need Help
  • v-hjannapu's avatar
    v-hjannapu
    8 months ago

    Hi eliasayyy,

    Thank you  for reaching out to the Microsoft fabric community forum.
    This is happening because Impressions has very big values compared to Clicks and Spend, so Power BI automatically sets the Y-axis based on Impressions and the other two look almost flat. Right now, Power BI does not support auto-scaling the Y-axis based on the measure selected through Field Parameters, and there is no DAX that can dynamically control the chart axis like that. The only practical options are to use a secondary Y-axis for smaller measures, keep separate charts for high and low value metrics, or convert the values into percentages or index format so the trends are visible.

    Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
    Regards,
    Community Support Team.

v-hjannapu's avatar
v-hjannapu
Community Support
8 months ago

Hi eliasayyy,

Thank you  for reaching out to the Microsoft fabric community forum.
This is happening because Impressions has very big values compared to Clicks and Spend, so Power BI automatically sets the Y-axis based on Impressions and the other two look almost flat. Right now, Power BI does not support auto-scaling the Y-axis based on the measure selected through Field Parameters, and there is no DAX that can dynamically control the chart axis like that. The only practical options are to use a secondary Y-axis for smaller measures, keep separate charts for high and low value metrics, or convert the values into percentages or index format so the trends are visible.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Regards,
Community Support Team.

v-hjannapu's avatar
v-hjannapu
Community Support
7 months ago

Hi eliasayyy,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Community Support Team.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    7 months ago

    Hi eliasayyy,
    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


    Regards,
    Community Support Team.