Forum Discussion

jomask's avatar
jomask
Frequent Visitor
1 year ago
Solved

separate values into columns

Hello community, I'm a new user of Power BI and would like to know how to move values from  from  column to additional columns that will contain only , closed, stand, none, enhanced values, see pictu...
Need Help
  • dufoq3's avatar
    dufoq3
    1 year ago

    Hi, if you have space in Promoted Headers, you have to use #"Promoted Headers" as reference so replace Values step with this:

    = List.Buffer(List.Sort(List.Distinct(#"Promoted Headers"[StateOfProceedingID])))
jomask's avatar
jomask
Frequent Visitor
1 year ago

Hello, one more question , I would liked to do a Pie chart from the Case column. It would show(count) Case1,Case2,Case3,Case4,Case5. How can I do that? Once again Thank you