Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi,
I am struggling with the following.
I have a table like this:
I have created a measure with the 2023 YoY growth of Value for every Source.
And another measure with the average YoY growth of all the sources.
I want to created a visual like this:
To have the label only on the last point of the average line, I want to create a measure called e.g. "Average Point". So I need to return the "SourceDate" value for the Source with the lowest growth (I will have the chart sorted by YoY, descending).
I thought this would be easy, I've done this already with CALCULATE, a measure and a filter for the last quarter. But in this case, I've tried different solutions and it does not work.
Thanks a lot for your help!
Solved! Go to Solution.
@mgarcianxp , for line you can use constant line in analytics pane with fx , you can use a measure
consider Index function
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
@mgarcianxp , for line you can use constant line in analytics pane with fx , you can use a measure
consider Index function
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Thank you!! it worked perfectly!
User | Count |
---|---|
84 | |
70 | |
68 | |
58 | |
50 |
User | Count |
---|---|
43 | |
41 | |
34 | |
34 | |
30 |