Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a form in CRM that has over 200 columns. These colums' values vary from 0, 0.5, 0.75 and 1. I want to be able to generate visuals such as bar graphs using this columns and be able to count the specific values of the columns. For example, the of 0's and 1's in a certain column.
Solved! Go to Solution.
Hi @Kins_ ,
Here are the steps you can follow:
1. Unpiovt column in Power Query for columns that need to be calculated.
Ctrl +A to select all.
Ctrl + Left mouse click + Cancel columns that do not need to be calculated.
Transform – Unpivot Columns.
2. using matrix visual - place [Value] columns in Rows and Value respectively and set Count in Value.
3. In visual filter - Basic filtering - set 0 and 1.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @v-yangliu-msft
Thank you this it really helps. Please assist on this, NB: the form includes a column labeled “Police Station”. To narrow down the data, I intend to create a list that specifically highlights those police stations where the count of zeros in a certain column is approximately five. How can I achrive that? Add the bar graphs should look like this,
Thanks,
Hi @Kins_ ,
Here are the steps you can follow:
1. Unpiovt column in Power Query for columns that need to be calculated.
Ctrl +A to select all.
Ctrl + Left mouse click + Cancel columns that do not need to be calculated.
Transform – Unpivot Columns.
2. using matrix visual - place [Value] columns in Rows and Value respectively and set Count in Value.
3. In visual filter - Basic filtering - set 0 and 1.
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly