cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mah65
Resolver I
Resolver I

Cuts in the KPI card viz!

Hi

I am visualizing a measure in KPI card as a function of "Start of Month". For comparison, I am also showing that in an area chart. There are two months for which there is no data (Imagine there is no sale for those two months). This is why there are two cuts in the KPI card. However, the area/line chart covers the cut beautifully. Both plots are as a function of "Start of Month".

 

How can I show the measure in the KPI card as it is shown in the line/area chart? I don't want the cuts to happen.

Thanks very much.

 

cumulative calculation.png

4 REPLIES 4
v-gizhi-msft
Community Support
Community Support

Hi,

 

According to your description, i create a sample to test:

30.PNG

I advise you using Dual KPI visual, it shows the result without cuts in visual:

1.jpg

Hope this helps.

 

Best Regards,

Giotto Zhi

 

 

Thanks

 

Does it also change the color automatically from green to yellow to red depending on the KPI threshold?

Check this video for Custom KPI Visual.

 

https://www.youtube.com/watch?v=zHzSBNES6jE

Greg_Deckler
Super User
Super User

That is because the line chart x-axis is probably set to continuous vs categorical. Not sure if there is a setting for that in the KPI visual

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors