Forum Discussion

tiztrain's avatar
tiztrain
Helper I
5 years ago
Solved

Graphing a Column with Multiple Values in One Field

Hi, So I have a field that has multiple values captured in the column seperated by a comma. 3rdpartworks,encroachment,midas,sms,stakeholder,tenure encroachment 3rdpartworks,encroachment ...
bar chart
DAX
  • jameszhang0805's avatar
    jameszhang0805
    5 years ago

    unpivot the table after you splited column. then create measure countrows(table). put the dimension column and measure into chart

  • stevedep's avatar
    stevedep
    5 years ago

    Here you go:

     

     

     

tiztrain's avatar
tiztrain
Helper I
5 years ago

Thanks guys.

Man that GIF makes things easy to follow these days