Forum Discussion
Create KPI with stablished goal
Hi guys!
I have a little trouble, I already calculated the % of transactions made by companies website, so I must to create a KPI showing the % reach vs the goal stablish. It´s seems very simple but I cannot use the % stablish since is not on a measure. Help!!
I´m able to calculate the % "reached" and I already have the % "goal"
The goal is provided by a table
To push the % "goal" I try almost everything but it´s extract the percentage like a average or maximum or minimum, never as the real value
I already try all, value, values, count. How can I extract the real value? I thought extracting with average and then using a filter it will works, but no. "Reached" changes but month filter but "Goal" keeps a average.
And then I use this
In order to change the colors.
I´m very rookie with this, sorry
Anonymous You need to make sure your DimDate filters your Meta table - your relationships points the wrong way. Set it to one to many with the one on the Date side and that will fix your problem:
https://excelwithallison.blogspot.com/2020/10/datekey-how-to-relate-your-date-data.html
5 Replies
- AllisonKennedy
Community Champion
Anonymous , Your Goals have one value per month, but your card visual only gives 1 value for Reached - how does Power BI know which month to compare to? You need to provide the month in the visual or measure calculation so it knows which goal value to use.
Can you give us a bit more detail?
- AllisonKennedy
Anonymous You need to make sure your DimDate filters your Meta table - your relationships points the wrong way. Set it to one to many with the one on the Date side and that will fix your problem:
https://excelwithallison.blogspot.com/2020/10/datekey-how-to-relate-your-date-data.html
- mahoneypat
Microsoft Employee
From the picture of your slicer, it looks like that is DateTime type while your Date table is Date type. Please make sure they match, and that you change it to Date type in the query editor (not just in the Data View window).
Pat
