Make a New Table that affected by Slicer

[nabilamj]

Hi All,

I have an Existing Table below, with the "Project Name" column as the slicer column

Project Name	User ID	Total - A	Total - B	Paid - A	Paid - B	Remaining - A	Remaining - B
Star	O123	100	20	80	10	20	10
Star	O345	100	20	80	10	20	10
Moon	O567	100	20	80	10	20	10

I want to make a New Table based on the Existing Table like below (or the transposed version should be okay too)

Category	Total	Paid	Remaining
A	300	240	60
B	60	30	30

or

Category	A	B
Total	300	60
Paid	240	30
Remaining	60	30

I want to create a bar chart from the New Table like below

and I want the New Table (and the bar chart) to be affected by the Project Name slicer. Should I use DAX or Power Query? Or I can directly create the graph on the dashboard without creating a New Table first, If yes how?

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[lbendlin]

and I want the New Table (and the bar chart) to be affected by the Project Name slicer. 

That is not possible either in DAX or Power Query.  You cannot create a calculated table from user input.  (It can be an intermediate step in a measure, as a table variable, but the final result of the measure needs to be a scalar value).

Reformulate your request - replace "Table"  with "table visual".  That can be done.  Same for the column chart.