If there a way to have the current month by default in a KPI representing MoM in Power BI

0 votes
I ran into a problem when attempting to include a fast measure (MoM percent) in a KPI. When no filters are applied, the KPI displays the month-over-month difference between December last year (2021) and November this year (2021), rather than the current month Feb (2022) vs Jan (2021). (2022). I have a calendar table with simple measures, but I'm stumped as to why I can't show the default value. I'm guessing I need to add something to the formula linked to the filter context, but I'm not sure what it should be. I've included an image below so you can see what I'm talking about. Instead of DEC last year, I want the value in the red area to be displayed on the KPI.
Feb 16 in Power BI by surbhi
• 3,810 points
897 views

1 answer to this question.

0 votes
The PREVIOUSMONTH DAX function can be used to always view the previous complete month. You can use this approach with ALL in the filter index to disregard any filter that might be applied, and then reference your measurements with this new one. Then you should always be able to see the most recent complete month.
answered Feb 16 by CoolCoder
• 4,360 points

Related Questions In Power BI

+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
12,082 views
0 votes
1 answer

What are the components I need to excel to become a pro in power BI

Having knowledge about these topics is a must.  Power ...READ MORE

answered Oct 8, 2018 in Power BI by Kalgi
• 52,350 points
349 views
0 votes
1 answer

By default, which level of filter behaves as same as a slicer in a report in Power BI desktop?

Hey, There are several types of filters in ...READ MORE

answered Jan 31, 2020 in Power BI by Rakesh
3,744 views
0 votes
1 answer

How to create a new dashboard by pinning visualizations from a report in Power BI?

Hey, I can show some steps wise steps ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,890 points
521 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
663 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
1,971 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,570 points
708 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
868 views
0 votes
1 answer

Power BI: Giving users the option to include or exclude a type of data

The best option, in my opinion, is ...READ MORE

answered Feb 18 in Power BI by CoolCoder
• 4,360 points
1,027 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP