Cuts in the KPI card viz!

[Anonymous]

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.

[v-gizhi-msft]

Hi,

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

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

Hope this helps.

Best Regards,

Giotto Zhi

[Anonymous]

Thanks

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

[smarthp29]

Check this video for Custom KPI Visual.

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

[Greg_Deckler]

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