How to split each of the grouping data into charts using Dax without creating new tables

[Anonymous]

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

[Ashish_Mathur · Accepted 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".  

[FarhanAhmed]

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://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-conce...

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

[Anonymous]

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.