Forum Discussion
Creating graphs and other visuals
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.
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
2 Replies
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 Anonymous
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,
