Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am using the KPI visual, but it is not working.
I have a measure that calculates the spending and another measure that is the goal of that spending.
When I use the cards, it shows the correct values for each measure, but when I put them in the KPI is does not show the correct data.
Not sure how to fix this.
Thanks!
Hi @LuisGerardoSR ,
It may be because you didn't sort by FiscalMonth. KPIs don't have a sort option. You'll need to start again and sort by FiscalMonth before you convert your visualization to a KPI.
Reference: Create key performance indicator (KPI) visualizations
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @LuisGerardoSR,
I have struggled with KPI visual in the past.
What i found useful is as below (There are 100s way for doing the same)
For Eg you have 2 measures
MEASURE1 = Which calculates the spending
MEASURE2 = Goal of that spending
Create a new Measure and use DAX as below-
This gives more flexibility to maintain and show KPI's.
not quite, I would like to stick to the KPI visual, I need to show the information just as that visual lays it out.
Please help.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |