Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey Everyone,
I have the below input tables, in which 1st table has the user details and 2 table has user details, activity conducted by user and date of activity.
Table 1
Table 2
I am trying to identify the % of total user who had activities in a specific month/quarter using a slicer as shown in the below image. For example, In April 2023, only 1 user is scheduled to have an activity and the output in the visual am expecting is 10% as there is only 1 user out of 10 total user who has activity in April. However, the stacked column chart when I use, It shows 100% all the time. Can anyone please let me know how I can get this.
I know this is pretty basic, but I don't know where I am missing to get the results.
Looking for any approach or solution to get the desired results.
TIA
Cheers,
Praj
Thanks @amitchandak for your response.
I did try the above measure and added that to chart however, the chart still displays the same result as 100% everytime
Cheers,
Praj
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |