PowerBI - visualization settings issue

Question

hello Dears,

Below table is my RAW Data. The number of Enrolled Users is increasing, while the number of Unenrolled Users is decreasing month by month.

	Location	Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24
Enrolled Users	Country A	28	31	58	61	68	73
Enrolled Users	Country B	4	10	20	20	25	27
Unenrolled Users	Country A	49	46	19	16	9	3
Unenrolled Users	Country B	23	17	7	7	2	0
Total Users	Country A	77	77	77	77	77	76
Total Users	Country B	27	27	27	27	27	27

In PowerBI, I have added two visualization components: a slicer and a donut chart. What I want to achieve is:

When no month is selected in Slicer, that the number of Enrolled and Unenrolled users displayed in the donut chart is the same as the last month (currently June), rather than a sum of the past few months. (because the total users only 103)

How can it be achieved? Thanks！

Answer 1

Hello Yaru_924，

Welcome to the Microsoft Community.

I wish I could handle your question, however, this community rarely deals with such issues questions involving Power BI are better suited to be posted in the Power BI Community, where more users discuss them. You can ask your questions there and there are experts there who can provide you with more specialized solutions.

You can join the Power Automate Community by clicking on this link and discuss your issue with the experts and users there:

Power BI forums - Microsoft Fabric Community

I hope that after contacting the right community your issue will be resolved as soon as possible!

Best regards,

Ian - MSFT | Microsoft Community Support Specialist

Answer 2

thank you, got this