Sparkline not showing correctly in Power KPI Matrix

[pborah]

Why is the sparkline of my second comparison value a flat line? In the screenshot below, the blue line is current year (2021), target is last year (green line, 2020), and prior is two years ago (orange line, 2019). However the orange line is not supposed to be flat. The count two years ago also varied month to month much like the other years/lines. However Power KPI matrix is only showing the total for 2019 (orange line) in the visual. 

My field settings are - 

And I'm using "Column based KPI" in table settings with metrics as columns.

Also if anyone can help me figure out how to ge the symbols to show similar to the Power KPI Matrix sample visual below, that would be fantastic.

Thank you.

[v-janeyg-msft]

Hi, @pborah 

Can you share the code of this measure? Only one screenshot is hard to judge.

You can check the video below to learn about the usage of kpi matrix visual:

Introduction to the Power KPI Matrix - YouTube

Introduction to Power KPI Matrix custom visual -version 2 - YouTube

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[pborah]

Sorry about the delay,

The code for the measures are - 

Year-to-Date (YTD) Current Year = TOTALYTD(COUNT('Reports WeeklyReporting'[evt_rin]),'CALENDAR'[Date])

YTD Last Year for Same Period = CALCULATE([Year-to-Date (YTD) Current Year],'Calendar'[Date] <= DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))

YTD Two Years Ago for Same Period = CALCULATE([Year-to-Date (YTD) Current Year],'Calendar'[Date] <= DATE(YEAR(TODAY())-2,MONTH(TODAY()),DAY(TODAY())))

[v-janeyg-msft]

Hi, @pborah 

This seems to be a measure and what's the content? Is there a date slicer in your report? It may affect the results.

Best Regards,

Community Support Team _ Janey

[pborah]

Yes this is a measure. Am I not supposed to be using one for this visual? Can you please explain further on -

---

 and what's the content?

---

There are no date slicers. The report shows current YTD for certain categories. Compared with YTD for the same period last year and two years ago. There is no further requirement to use a date slicer on this report for the user to be able to adjust the dates and play around. Thank you.

[v-janeyg-msft]

Hi, @pborah 

Sorry, Because you don't provide any data, and it is hard for me to judge based on only a few pictures and code without grammatical errors.

I'm asking about the code of your measure '[Year-to-Date (YTD) Current Year]'. If one measure is used in another measure, if the measure is more complicated, it is very likely to make mistakes. Secondly, using YTD this kind of time intelligence function is also very likely to go wrong. This is related to your date column, is it continuous?

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

[pborah]

No problem. Sorry there is a bit of confidentiality to the data. Is there any way I can send you a sample pbix privately?

[v-janeyg-msft]

Hello, @pborah 

You only need to share a sample that doesn't contain sensitive data, it needs to meet the test requirements,and no real data is required. Due to the nature of work, we can only reply in the forum.

If you still need help, pls let me know.

Best Regards,

Community Support Team _ Janey