Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.