Y-axis format in dynamic column/line chart

[MadBern85]

Hi

I have a dynamic column/line chart where end users can use slicers to view and analyze different results.
The columns are controlled by one slicer that shows, for instance, company total revenue and the line is controlled by another slicer which shows other results, which can be in either numbers or percentages. But all percentages in y-axis and datalables are shown as numbers.

Here is the measure for the line values:

Parametre1 = SWITCH(TRUE(),
SELECTEDVALUE(LineFilter[Parametre1]) = "Revenue pr. hour", [Agent RPH],
SELECTEDVALUE(LineFilter[Parametre1]) = "Total absence", [Total absence %],
SELECTEDVALUE(LineFilter[Parametre1]) = "Paid absence", [Paid absence %],
SELECTEDVALUE(LineFilter[Parametre1]) = "Profit %", [Profit %],
SELECTEDVALUE(LineFilter[Parametre1]) = "Utilization", [Utilization],
SELECTEDVALUE(LineFilter[Parametre1]) = "Occupancy", [Occupancy],
SELECTEDVALUE(LineFilter[Parametre1]) = "No of sales", [No of sales],
SELECTEDVALUE(LineFilter[Parametre1]) = "Sale Hitrate", [Sale Hitrate])

I've tried using the FORMAT-function in this measure, but that has only resulted in the values going missing from the chart.

Anyone have any tips for how I can get the chart to show the correct format of the data or is this not possible in a dynamic chart like this?

Regards
MadBern

[amitchandak · Accepted solution]

@MadBern85 , You can do that in the calculation group

calculation groups

https://www.youtube.com/watch?v=vlnx7QUVYME
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/