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 would like to show Total Count for the next 5 years from today when I select certain year in the year slicer. It will be dynamic and If i select year 2024 it should show total count for next 5 years starting from 2024. If i do not select any date, it should show total count for next 5 years from today.
I tried some formulas however result was same as the total count.
Thank you very much in advance
Solved! Go to Solution.
Hi @GrimReaperX
You can refer to the following example.
The slicer table
The data table
Create a measure
Measure = IF(ISFILTERED('Table (2)'[Column1]),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>SELECTEDVALUE('Table (2)'[Column1])&&'Table'[Column1]<=SELECTEDVALUE('Table (2)'[Column1])+5)),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>YEAR(TODAY())&&'Table'[Column1]<=YEAR(TODAY())+5)))
Then put the column of slicer table to the slicer and create a table visual and put the data of data table and measure to the visual.
Output
When the silicer is not chosen.
When the slicer is chosen
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GrimReaperX
You can refer to the following example.
The slicer table
The data table
Create a measure
Measure = IF(ISFILTERED('Table (2)'[Column1]),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>SELECTEDVALUE('Table (2)'[Column1])&&'Table'[Column1]<=SELECTEDVALUE('Table (2)'[Column1])+5)),CALCULATE(SUM('Table'[Column2]),FILTER('Table','Table'[Column1]>YEAR(TODAY())&&'Table'[Column1]<=YEAR(TODAY())+5)))
Then put the column of slicer table to the slicer and create a table visual and put the data of data table and measure to the visual.
Output
When the silicer is not chosen.
When the slicer is chosen
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |