Custom visual - bar chart not working

[jana1]

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

[GeorgeBuster]

Hi Jana 1,

Do you want the same bar chart of the excel in Power BI?

[jana1]

Yes. 

[GeorgeBuster]

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             45

You 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.

[jana1]

Can you teach me from strating as I am new to BI.

[GeorgeBuster · Accepted solution]

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.