Forum Discussion
Can't Get KPI Visual to work with Multiple Tables
I actually solved this just now, using a new visual calculation and calculating the RUNNINGSUM.
Hi PatrickMcLeanGL ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Ashish_Mathur DataInsights Thank you for your quick response.
PatrickMcLeanGL ,I have created a sample Power BI file and included a KPI visual based on the sample data. Please review the file and confirm if it meets your expectations. If not, kindly share your sample data along with the desired output, so I can make the necessary adjustments accordingly.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
So I had mine set up exactly like that, but it doesnt work when a date range is picked. So if I had my date selected as 2 days, I would want the sums of each value compared. Even in the PBIX you shared, it only shows the most recent date's value if both dates are selected. Ideally I actually dont want an external filter selection, I want the filter baked into the visual because I'm going to have a KPI for each employee. So in your example, I'd want 2 KPI visuals, one for John and one for Alice, with a date slicer, and if I picked both dates April 1 and 2, for Alice it should show 11/13 (5/6 + 6/7) and Johns would show 15/17 (10/11 + 5/6).
You can see here that for March 21st and April 3rd (single dates), it works and its accurate.
But when I select a range between the two dates, it only shows most recent data (from April 3rd) in the KPI card, it should show the values in the two "Card" visuals to the left:
Heres my data:
I want the KPI to show the total value for the date range.
I actually solved this just now, using a new visual calculation and calculating the RUNNINGSUM.