Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Switch statement to return chat values

hello all,   i have this sample data in Power BI:   Users Salesmembers Managers Cars Phones Expenses pagers 10,205 1,500 500 2,000 2,000 1,503 1,500   What I am trying to c...
  • Anonymous's avatar
    Anonymous
    6 years ago

    yes! thank you so much

  • smpa01's avatar
    smpa01
    6 years ago

    One thing, for you to display the CATEGORY level - managers, cats etc etc on the X axis, DAX would need a table that contains those values in a single column.

     

    You can either achieve it by creating a table on-the-fly like I did and have the visual created form table 2 or by creating a disconnected table as DCN in the example and then SWITCH !!!! 😂😂