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

Anonymous's avatar
Anonymous
Not applicable
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