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

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

 

 

Anonymous
Not applicable

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.