Forum Discussion
F_Reh
2 years agoPost Patron
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 c...
F_Reh
2 years agoPost Patron
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 ?
- Gabry2 years agoSuper User
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.