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 all
I would like to show data only for 2016.
But my data have record from 2014. I dont prefer to filter using Page level filters as the date from 2014 is more than 500++ and it's not really practical.
Kindly advise how can I filter my data to shown only date from 2016
Solved! Go to Solution.
Hi @aanmi,
Why not use Advanced filtering of the Page level filters? As shown in the following screenshots, you are able to set date value to 2016 and later.
Thanks,
Lydia Zhang
Hi @aanmi,
Why not use Advanced filtering of the Page level filters? As shown in the following screenshots, you are able to set date value to 2016 and later.
Thanks,
Lydia Zhang
1. If you will never be displaying data from 2014 till 2015 Dec, it would be easier to skip those records while loading in the query.
Alternatively
2. Do you have a calendar or date table in the data model?
3. If so create a column called Show as
Show = If ( CalendarTable[Year] >= 2016 , 1 , 0 )
what this means is if the CalendarTable Year is >= 2016 then set Show as 1 else set Show as Zero.
4. In your chart , set the visual filter as Show Equals 1.
Try it out.
If this solves your issue please accept it as a Solution and also give KUDOS.
Cheers
CheenuSing
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |