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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Unable to configure count per month on a matrix table

Hello,

 

I am trying to configure a table with count per month and I am struggling...

 

I have different types of projects. Each of them have to go through different gates for the project to be completed. I want to have a table which shows how many gates have been passed on that specific month per project type.

 

Example:

Type of projectgate 1gate 2gate 3gate 4

type 1

jan 2023jan 2023march 2023 
type 1jan 2023feb 2023  
type 2jan 2023march 2023march 2023 
type 3feb 2023feb 2023march 2023march 2023

 

What I want is this:

 

 jan 2023feb 2023mar 2023
gate 1

2

1

0

gate 2

1

2

1

gate 3

0

0

3

gate 4

0

0

1

 

is this doable?

 

Thank you!

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , My advice would be to unpivot the gate columns in power query

 

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

 

Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s
Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.