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.
Hi Everyone,
I am having troubles with the Microsoft KPI visual and hoping you all can help. I would publish my pbi file, but apparently I don't have enough creditability yet. Below you will see my table that I am visualizing. I want to show the most recent completed month therefore I am using the "Month Completed" column in my filters. The KPI works great until I want to filter to a certain range of Months. For example, If I want to see Q4 in 2022 then I filter to Oct. 2022, Nov. 2022, and Dec. 2022. However the KPI doesn't aggregate the three months like I need. It only shows the last month - Dec. 2022.
Raw Data:
KPI Before Filtering
KPI once filtered. I would like this to aggregate the three months I have selected rather than show the most recent month.
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |