'Create a column in power Bi Based upon selection
Recently I came up with this problem: I have a table with two different codes: COD1 and COD2. I want to create in power bi bar charts and tables with this information but I want to be able to change whether if I want to see them with COD1 or COD2. I have a slicer that gives you the option of which code you want the info be displayed. I've done this before with numeric data types because you can do this with a measure, however I don't know how to make it work with non-numeric columns.
| COD1 | COD2 | Sales |
|---|---|---|
| AA | A10 | 5 |
| AB | B45 | 10 |
| CD | D44 | 20 |
Solution 1:[1]
I'm not exactly sure what you're trying to achieve but if I understand you correctly, you can change columns on a bar chart by making two bar charts. One will have COD1 as an axis with Sales, and the other will have COD2 as an axis with the same sales metric.
You could then use buttons and the bookmark functionality of Power BI to seamlessly "switch" the axis. See an example below:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | codyho |