cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

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 @Beginner_2020,

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
Community Support
Community Support

Hi @Beginner_2020,

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.
Super User I
Super User I

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!




Super User I
Super User I

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!




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 @Beginner_2020,

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors