Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Just let the following pics describe the question. Here's how the dataset looks like.
Item | Borough | Store | Amount |
0001 | manhattan | store1 | 26 |
0001 | manhattan | store2 | 22 |
0001 | brooklyn | store3 | 23 |
0001 | brooklyn | store4 | 27 |
0001 | bronx | store5 | 13 |
0001 | bronx | store6 | 7 |
0001 | queens | store7 | 21 |
0001 | queens | store8 | 16 |
0001 | staten island | store9 | 5 |
0001 | staten island | store10 | 2 |
0002 | manhattan | store1 | 45 |
0002 | manhattan | store2 | 57 |
0002 | brooklyn | store3 | 36 |
0002 | brooklyn | store4 | 33 |
0002 | bronx | store5 | 11 |
0002 | bronx | store6 | 14 |
0002 | queens | store7 | 25 |
0002 | queens | store8 | 31 |
0002 | staten island | store9 | 8 |
0002 | staten island | store10 | 2 |
And I tried to create the charts below so that I can casually allocate the position of each bar chart (based on the Borough) in the dashboard as I want. (The chart below is my expected result.)
However, the way I tried is to split the whole dataset into several tables to implement it. Like this.
So, my question is that is there a way which I can only import the dataset into Power BI with one table and use Dax function to create new columns/measurements for creating the dashboard above? Thanks
Solved! Go to Solution.
Hi,
Create a bar chart and filter only that visual on Manhattan. Create a copy of it and filter it only on Brooklyn. You may also want to explore "Small multiples".
Hi,
Create a bar chart and filter only that visual on Manhattan. Create a copy of it and filter it only on Brooklyn. You may also want to explore "Small multiples".
You can use Append Queries to combine all of your data.
You may also want to include source table name in Append queries so that data can be differentiate in segmentation.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://community.powerbi.com/t5/Desktop/Append-Queries-Add-Source-Table-Column/td-p/1050391
Proud to be a Super User!
Hi, @FarhanAhmed
Thanks for ur reply, but I dont want to append the table actually. That's to say, originally I have one main table, which is below, and trying to make several bar charts based on the column, Borough. But, I dont know how to implement it without splitting the main table into several ones.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |