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 create is a chart like this:
What I have done is created a disconnected table with all the categories and placed that measure in the axis.
| Category |
| Users |
| Salesmembers |
| Managers |
| Cars |
| Phones |
| Expenses |
| pagers |
Now I need to use a DAX meaure to place in the visual to return the correct values.
how can I do this with DAX?
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 !!!! 😂😂
15 Replies
I am not sure whether you wanted PBI to render the chart or want a switch statement. PowerBI can return the same chart without needing a switch at all.
Does this work for you?