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.
Hello,
I have years in a slicer and a line graph, and I need to display data starting from the year selected in the slicer? How to do that?
Thanks for your help.
@Wattar
You can put your sample pbix file on Onedrive for business, and then share the link here.
Paul
@Wattar
Basically, you need to create measure to make visual dynamic, and "enter value " create a slicer table, the the new Year column as the slicer. Check the example pbix for detail.
Value Measure = CALCULATE(MAX([Value]),FILTER('Table',[Year]>=SELECTEDVALUE('Table (2)'[Year Slicer])))
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@V-pazhen-msft , thanks for your reply.
It seems right but I couldn't reproduce your solution.
I can't find how to upload my workbook.
Thanks
I hope it's clear with an image, the grpah displays all the years where there are data, but I need to only show the years starting from the year selected in the slider:
could you please share the sample data and expected output?
Proud to be a Super User!
@Wattar , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |