Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Transformation of table and filtering



Hi All


I am new to the Power BI concept and would appreciate some help/guidance.


Situation, I have a table of inventory/products which have some deliverables at various stages that I want to be able to visualize in a more presentable way. I have made a simplified sample of what I need some help with.


2019-07-19, Product table.JPGProduct TableSteps

  • Basic product table (excel) with deliverables; the deliverables availability, state and hour estimation/progress
  • Imported to Power BI
  • For making the sorting by deliverables (1: Sales, 2: Standard ...) I have made some pivot transformation and merging so that I can sort the data by deliverables (might be done more elegant...)

2019-07-19, Product presentation 0.JPG


  • I have prepared some measures to get the estimated hrs, executed hrs, remaining hrs which work on the total amount of products  but not for Deliverable Availability and State (Deliverable table filter not working properly)

2019-07-19, Product presentation 1.JPGPower BI report

Help needed for (red arrows indicate where I need help):

  • Making a proper table transformation so that I can filter/slice by Category, Type, Deliverable (1: Sales, 2: Standard ...) 
  • Make the cross filtering work so that if filters for the charts shown and tables.

Any help would be appreciated. I can send the files if needed...






Regular Visitor

Re: Transformation of table and filtering

Link to files:

Excel and report

TeigeGao Solution Sage
Solution Sage

Re: Transformation of table and filtering

Hi @Holgarsson ,

The pbix file you shared is not a public link, I have no permission to access this file.

Best Regards,


Regular Visitor

Re: Transformation of table and filtering

Hi @TeigeGao 


Company Policy...


Please find attached a new link to the sample files






Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors