Forum Discussion
Showing multiple text columns with a bar chart
Hi,
* new to powerbi
** actual client data is different
I have a dataset which looks like this.
| Dealer | Dealer Sub location | Inventory Age |
| H140 | Mumbai | 90 |
| H141 | Goa | 120 |
| H142 | Delhi | 130 |
| H143 | Pune | 70 |
| H144 | Chennai | 60 |
| H145 | Hyderabad | 85 |
| H146 | Bangalore | 40 |
I want it to be displayed like this : (tableau screenshot) (with 2 columns and then the bar)
However, i was able to get only one column and not both the columns before the bars.
Any help on this would be highly appreciated.
Hi Anonymous
Two workarounds you could take into consideration.
1.In the stacked bar chart, add "Dealer" and"Dealer Sub location" to Axis field, then click on the fourth icon (double arrow) "at the lowest level".
2. in the table visual, create a measure
Measure of Inventory Age = SUM(Table1[Inventory Age])
select "conditional formatting"->Measure of Inventory Age->"data bar"
Best Regards
Maggie
3 Replies
v-juanli-msftCommunity Support
Hi Anonymous
Two workarounds you could take into consideration.
1.In the stacked bar chart, add "Dealer" and"Dealer Sub location" to Axis field, then click on the fourth icon (double arrow) "at the lowest level".
2. in the table visual, create a measure
Measure of Inventory Age = SUM(Table1[Inventory Age])
select "conditional formatting"->Measure of Inventory Age->"data bar"
Best Regards
Maggie