Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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 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.
Can you teach me from strating as I am new to BI.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |