Forum Discussion

asheet_s's avatar
asheet_s
Frequent Visitor
3 years ago

Bar chart for categorical data count

I have a dataset like this:        UserID      Roles 01ffe0 Read, Write, Approve 4abb4 Read 6yhc82 Approve, Write 02efaf Write 1bcf5d Read, Write   How to display the co...
Need Help
Tips and Tricks
ichavarria's avatar
ichavarria
Icon for Solution Specialist rankSolution Specialist
3 years ago

Hi asheet_s,

 

I support ppm1. This would work. Please give it a try and feel free to reach back if you need any additional help. 

 

 

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly

 

 

asheet_s's avatar
asheet_s
Frequent Visitor
3 years ago

Hi ppm1 ichavarria 

 

Thnaks for the repsonse. One question - Where to insert the table name? 
If I have a table named [X_ROLE_CLASS], where should that name be placed? 

  • ppm1's avatar
    ppm1
    Icon for Solution Sage rankSolution Sage
    3 years ago

    You shouldn't need the table name. In the query editor, the key step is the #"Added custom" one where you reference your Roles column inside Text.Split.

     

    Pat

    • asheet_s's avatar
      asheet_s
      Frequent Visitor
      3 years ago

      Hi Pat,

      Actually the "UserID" I entered in this question is just a sample.
      If I'm using the UserID column from another table, how do I bring that to the query editor. Your binary64 code translation is something that I'm unable to modify.


      PS: I'm still have amateur level expertise in PowerBI

      Thanks