Plot a measure that is based on a parameter or create a dynamic calculated column
I have a paramater which sets a certain threshold value. This then looks at each row of my data and will estimate a date that particular row will meet that threshold. I have done it with a measure. I now have a table like this
What I want to be able to do is plot the counts of dates as a bar chart. Therefore count how many rows match that date and have the date as the x axis. I expect the visual will change when i change the threshold slicer.
This doesnt work sorry. What I should probably have explained better is this is the first table
its called JP outputs
I have a paramater called fire threshold. This is a slicer on my page. I have created a measure called threshold date which uses the value of fire threshold and calculates the date the fire risk will grow to that value
I then create a table visual and get
What I want to do is plot the target dates and the counts of notifications that have that date. I tried your method but I can't even use the measure that I created as an input
Slicer(get the value) -> [Target Date] (Use the value to create a measure) -> Use the measure as a bar chart's x-axis(This step does not work, x-axis only accepts entity columns as values.)
Best Regards, Gao Community Support Team
If there is any posthelps, then please considerAccept it as the solutionto help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know.Thanks a lot!