Forum Discussion
Custom visual - bar chart not working
Hi,
In the below link I have attached my dataset and I need to visualize this dataset in the bar chart with the TOTAL (attached right to the dataset). Please help me in this.
https://drive.google.com/file/d/117veuEgSAf79XqfUlJATzTIJGL7MLhfL/view?usp=sharing
Regards,
M Janarthanan
The easiest solution for you is go to the menu "Main>Enter Data" and build your table.
Power BI let you do marvellous dashboards, I'd recommend you to not try replicating and choose the best option for Power BI.
If you want to learn Power BI from the beginning here you have a free course:
https://www.edx.org/es/course/analyzing-visualizing-data-power-bi-microsoft-dat207x-8
Best,
Jorge.
5 Replies
Hi Jana 1,
Do you want the same bar chart of the excel in Power BI?
Yes.
Ok Jana1. First of all, I have to tell that your exact visualization, with your data, is not possible. If you want to add a total column, like you do, you have to build an auxiliary table with the summarized data.
Region Gender Quantity
Wichita Male 16
Wichita Female 12
Wichita Total 28
West Male 12
West Female 5
West Total 17
Total Male 28
Total Female 17
Total Total 45You can build it manually, with dax or in the query editor. After that, it is as easy as set your table fields:
- Axis: Region.
- Legend: Gender.
- Value: Quantity (it will transform into a function and it will work perfectly).
Best,
Jorge Bustillo.
