Making Line Constant Appear/Disappear

[F_Reh]

Good Morning,

I have implemented a Field Parameter for the Y-Axis for a particular Bar chart allowing the user to decide whether to show numerals or percentages. The issue is that I need a line constant - showing the percentage target - to appear only whenever the percentages option is selected. This line constant would be irelevant when the numerals option is selected (and thus hidden).

Kindly recommend if it is possible to solve this.

[Gabry]

man, you have a comma at the end of the third line, you should remove it

[F_Reh]

Thanks @Gabry . So the Field Parameter is as follows:

I have now created a new Measure _Rate = 0.04 (i.e 4%) for the line constant. So where would I need to add this so that the 4% line constant will appear only and only when percentage option is selected ?

[Gabry]

you have to add another column at that table

like this:

prmdnaz = {

("", nameof(first percentage measure),0, "Percentage"),

("", nameof(second percentage measure costant line),0, "Percentage"),
("", nameof(third absolute measure),0, "Absolute")

}

Then, in the slicer used to enable users to select which measure to insert into the table, you utilize the last created column. Therefore, when they select "Percentage," both measures will be added to the visualization.

[Gabry]

I think you can achive this by putting not a constant line in the format pane but by adding a measure that has always the same value and that act as a costant line. You can add this measure in the field parameter when the percentage is selected you'll have 2 measure in the chart, one with your values and one that is constant representing what you want.

I think this is an aceptable workaround, let me know what you think

bye