Forum Discussion
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...
yes! thank you so much
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 !!!! 😂😂
got it. My last question would be is it possible to create a seprate table pulling in only the data i need from the origional table?
meaning only pulling this data:
| Users | Salesmembers | Managers | Cars | Phones | Expenses | pagers |
| 10,205 | 1,500 | 500 | 2,000 | 2,000 | 1,503 | 1,500 |
into a new table so I can pivot
thank you so much for the help
Anonymous can you please provide me a source data which would have other undesired data and the final output that you desire.