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.
I have Dataset similar to below
Name | Assignment1 | Assignment2 | Assignment3 | Assignment4 | Assignment5 | Assignment6 | Assignment7 | Assignment8 |
Suj | 10 | 7 | 10 | 8 | 10 | 10 | 7 | 8 |
Swe | 8 | 9 | 8 | 9 | 10 | 7 | 9 | 9 |
Har | 9 | 7 | 9 | 8 | 10 | 9 | 8 | 10 |
Rit | 10 | 10 | 10 | 10 | 10 | 10 | 9 | 10 |
Hem | 5 | 6 | 5 | 7 | 8 | 7 | 9 | 9 |
And have created disconnected table with measure names for Dynamic visual change
And have written dax
HI @Harinihemanth06 ,
I recommend you to unpivot all your assignment 1 to assignment n and then use this into filter with multiple selection. Follow the below step to solve your issue:
Step 1: Go to Query Editor and select all assignments columns(say 1 to n) --> go to trnasform tab --> select unpivout column (attached screen shot below)
Step 2: Rename the Attribute column to Assignment Name. Close and Apply.
Step 3: Take the Assignment name into Slicer and enable multi select option. (SCreen shot is attached below)
Don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
@Tahreem24 Thanks for your valuable input since the data volume is huge un-Pivoting is not a best option.
I have chosen to go with multiple measures for the requirement.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |