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 a set of data which has pass and fail.
I need a slicer which has data like Student 1 ,Student 2 ...
If i select Student 1 it should update my Donut chat with how many subject Student 1 got Pass or Fail or No data or Pass - Conditional
Thanks in Advance
Solved! Go to Solution.
Hi @Ayappan ,
I would start by transforming your data in power query (click transform data).
You need to select the subject name column and then use "Unpivot Other Columns". https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...
this will give you a table with columns:
Subject, Student Name, Value.
Data in this form will be much easier to work with in Power Bi.
If Active/InActive is linked to the subject then go back to PowerQuery, remove the unpivot you previously did and then repeat the steps but this time select both the Subject column and the Active/InActive column before using Unpivot other columns.
Hi @Ayappan ,
I would start by transforming your data in power query (click transform data).
You need to select the subject name column and then use "Unpivot Other Columns". https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...
this will give you a table with columns:
Subject, Student Name, Value.
Data in this form will be much easier to work with in Power Bi.
Thanks @bcdobbs
That worked - After this i had added a column with Active / InActive .
So now i have to Filters .1st with pass or fail 2nd with Active / InActive
Should i follow same process or any other way it will help me .Please Suggest
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |