Power KPI Matrix comparing measure against reference percentage based on date

[deasons22]

I'm trying to compare these two percentages(one is a measure dividing to values, second is a reference table with targets per month) in the KPI Matrix, but my second data set ends up being a sum value of my entire table over being by date based percentages, so I end up with just a single value  to campare the entire dataset to.

Is this possible or is there a better way to go about this. 

Thanks

[v-viig]

It seems you just need to to fill the Second Comparison Value and turn on the Second Sparkline via Sparkline settings.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[deasons22]

I was having an issue with value being summed up when I did that. After I changed my target value column to a text I was able to compare against it. 

[deasons22 · Accepted solution]

Looks like you can change the datatype to text and it appears to work. I know there's an implicit converision happening, but at least it works. Seems like there has to be another way to make this work.