Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Is it possible that cards show only specific months without a filter?

Cards.PNG

Measure: Total Amount = count('Stammdaten Komplett'[ID])+0
FY 19/20 is correct and very nice but I need your advice on the 6 months and last month card. I filtert the last 6 or 1 month per month (example: only show July) but if i use the time slicer these to cards are useless of course.
Is there a way to calculated that the last month card always shows the last month without a specific filter (July, August...etc.)?

Thanks for your time! 
1 ACCEPTED SOLUTION

HI @Anonymous,

Maybe you can try to use date function instead of time intelligence functions in your formula. They not required a calendar table and can be nested with other functions.

BTW, can you please share some dummy data to test?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

5 REPLIES 5
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

You can consider adding a visual level filter on your cards to filter on specific data ranges or write switch functions in your dax expressions then it can return different results based on its row contents.

Add a filter to a report in Power BI 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Daviejoe
Memorable Member
Memorable Member

Also, do you have a date table?

 

https://community.powerbi.com/t5/Desktop/Create-a-measure-that-shows-me-the-previous-month/td-p/6030...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Daviejoe
Memorable Member
Memorable Member

These should help you

 

https://docs.microsoft.com/en-us/dax/previousmonth-function-dax

 

https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Thanks for the good information. I have a data table but my measure is this: 

 

Total Amount = COUNT('Stammdaten Komplett'[ID])

PM Count =
CALCULATE([Total Amount];PREVIOUSMONTH(Dates[Date])) is not right
 
Maybe the differance between count and calculate is the problem.

HI @Anonymous,

Maybe you can try to use date function instead of time intelligence functions in your formula. They not required a calendar table and can be nested with other functions.

BTW, can you please share some dummy data to test?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.