Forum Discussion

Kins_'s avatar
Kins_
Regular Visitor
2 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Kins_'s avatar
Kins_
Regular Visitor
2 years ago

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,