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.
Solved! Go to Solution.
Hi @Anonymous ,
I created a simple table as below:
Then create a measure as below:
Current Month Data =
IF(ISFILTERED('Table (2)'[Month])||ISFILTERED('Table (2)'[Year]),SELECTEDVALUE('Table (2)'[Sales]),IF(MAX('Table (2)'[Month])=MONTH(TODAY())&&MAX('Table (2)'[Year])=YEAR(TODAY()),MAX('Table (2)'[Sales]),BLANK()))
And you will see: (When you open the .pbix file,it will show):
When you select May,it will show:
For the related .pbix file,pls click here.
@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
See if this can help
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Appreciate your Kudos.
I have created a report whenever we have opened that report the data should be displayed current monthly data or current yearly data.
After that by selecting year or months we can select the as we want.
Hi @Anonymous ,
I created a simple table as below:
Then create a measure as below:
Current Month Data =
IF(ISFILTERED('Table (2)'[Month])||ISFILTERED('Table (2)'[Year]),SELECTEDVALUE('Table (2)'[Sales]),IF(MAX('Table (2)'[Month])=MONTH(TODAY())&&MAX('Table (2)'[Year])=YEAR(TODAY()),MAX('Table (2)'[Sales]),BLANK()))
And you will see: (When you open the .pbix file,it will show):
When you select May,it will show:
For the related .pbix file,pls click here.
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 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |