Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
My visual has values from January 2020 to December 2023. My requirement is when I open the report want to see the previous month and greater than previous month results. Also, I need the option to see "Full" values from Jan 2020 to December 2023.
I created this Dax query for filter the values, (// Append1 is table name)
2. When I select the Full option it shows up tp 10/1/222 from January 2020. Beacuse I gave <= previous month.
But, when I select "Full", I want to show upto December 2023. I don't know how to fulfill. Tried multiple ways, missing somewhere. What extra query I need to add here? Can someone help me solve this?
Thanks!
Solved! Go to Solution.
Hi, @Priya1969
You can try the following methods.
Measure = IF(SELECTEDVALUE('Table'[Date])<=[Previous_Month],1,0)
This is the default date.
The full date is displayed when this measure is cleared.
Hope this method helps you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Priya1969
You can try the following methods.
Measure = IF(SELECTEDVALUE('Table'[Date])<=[Previous_Month],1,0)
This is the default date.
The full date is displayed when this measure is cleared.
Hope this method helps you.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Thanks for the reply. It's almost correct. Instead of giving measures in 'fiters on this visual' option, I did something like this.
If i select, 'Select all' option, it shows all the dates.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
13 | |
9 |