Forum Discussion
Helper IPlot a measure that is based on a parameter or create a dynamic calculated column
Memorable MemberHi fingalbrad,
Use summarize to count the number of times a date appears in your result table:
Count Table = SUMMARIZE('Result','Result'[Date],"Count",COUNT('Result'[ID]))
Create the join between the dates in this table and Date table and use the Count column in the Y-Axis.
Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI
Helper IThis doesnt work sorry. What I should probably have explained better is this is the first table
its called JP outputs
| Notification | Fire Risk |
| 2 | 13000 |
| 3 | 14000 |
| 4 | 15000 |
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
| Notification | Target Date |
| 2 | 25/6/2023 |
| 3 | 29/7/2023 |
etc
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
HI fingalbrad ,
If I understand you correctly, you want:
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 TeamIf there is any post helps, then please consider Accept it as the solution to 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!
How to get your questions answered quickly -- How to provide sample data