Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |