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
Anonymous
Not applicable

metrics in powerBI

Hi Team,

Can we implement this in powerBI ?

 

 Metrix.PNG

 

Regards,

Suresh.

1 ACCEPTED SOLUTION
danno
Resolver V
Resolver V

The Matrix visual in power bi will give you the ability to split measures based on dimension values in rows and columns. In this example you have a categorisation in rows and a date in columns. This is easy to implement, the parts which do not fit easily into the matrix are the additional column for status. This would have to be calculated as a measure which could be added to Values in the Matrix but would appear for every cell in the matrix

To condense two into one, You could try using the status flag as a conditional format on the matrix to indicate whether the value has changed month on month, (or use the KPIs when they are released in Power BI soon) this would give a good visual indicator of the status on each cell in the matrix.

View solution in original post

4 REPLIES 4
danno
Resolver V
Resolver V

The Matrix visual in power bi will give you the ability to split measures based on dimension values in rows and columns. In this example you have a categorisation in rows and a date in columns. This is easy to implement, the parts which do not fit easily into the matrix are the additional column for status. This would have to be calculated as a measure which could be added to Values in the Matrix but would appear for every cell in the matrix

To condense two into one, You could try using the status flag as a conditional format on the matrix to indicate whether the value has changed month on month, (or use the KPIs when they are released in Power BI soon) this would give a good visual indicator of the status on each cell in the matrix.

please mark as solution if you dont need more help

 

Anonymous
Not applicable

HI Danno,

Thanks for your reply. Can you explai briefly. 

 

Regards,

Suresh.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.