Forum Discussion

Imagauthamam's avatar
Imagauthamam
Icon for Helper III rankHelper III
11 months ago
Solved

Dynamic Y-axis max on a shared line chart (measure switch + field parameter).

Dynamic Y-axis max on a shared line chart (measure switch + field parameter). Need fixed caps for “Sales Score” (100) and “Profit %” (100%) without breaking other metrics.   Setup One shared lin...
Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    11 months ago
    Detecting which field parameter option (D/W/M/Q/Y) is currently selected

     

    Not supported by the current design of the Field Parameters. Even worse, in multi select options you can not know the order in which the report user picked the values.

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi Imagauthamam  ,
Thanks for reaching out to the Microsoft fabric community forum.

For continuous axis tick marks, you cannot control the format string using built in options. Power BI chooses the best tick interval based on your data range, and creates a minimal format string for this unit interval, to preserve space.
Instead try this DAX approach and check if it works for you.

Y Axis Multiplier = 
VAR _metric = SELECTEDVALUE(Metrics[Metric Type])
RETURN
SWITCH(
    _metric,
    "Revenue", 1,          
    "Cost", 1.5,           
    "Margin %", 100,       
    1
)



I hope this information helps. Please do let us know if you have any further queries.
Thank you