Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi - I'm using this tutorial as the basis for adding an annotation.
https://community.powerbi.com/t5/Webinars-and-Video-Gallery/Annotating-Specific-Events-in-Line-Chart...
I am using a Slicer to display information by city. What I want to show is 'implemention begins' in each of the 31 cities in the Slicer.
I have:
You should be able to do something like:
Note = VAR __city = MAX('Table'[City]) RETURN SWITCH( MAX(India[reportingdate] ), VALUE("10/1/2017" ), "Implementation begins in " & __city, VALUE("04/1/2018" ), "Implementation begins in " & __city, VALUE("05/1/2018" ), "Implementation begins in " & __city, BLANK() )
HI Greg, thank you so much, this is working. I'm wondering if you could help me around two issues I'm having:
1) When all the filters are selected, it shows a few random implementation dates - is this an IF statement, such as 'IF ALL Filters are selected, then show no dates"?
2) What would I need to do to show multiple start dates if more than one filter is selected?
Thank you, I appreciate your time.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |