Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
nabilamj
Regular Visitor

Make a New Table that affected by Slicer

Hi All,

 

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

Project NameUser IDTotal - ATotal - BPaid - APaid - BRemaining - ARemaining - B
StarO1231002080102010
StarO3451002080102010
MoonO5671002080102010

 

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

CategoryTotalPaidRemaining
A30024060
B603030

or

CategoryAB
Total30060
Paid24030
Remaining6030

 

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

nabilamj_0-1692861182702.png

 

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?

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Ashish_Mathur_0-1693026514839.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

 

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.