Forum Discussion
Making Line Constant Appear/Disappear
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.
5 Replies
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
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.
man, you have a comma at the end of the third line, you should remove it
