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
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