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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Compare two columns in a matrix visual based on measures

Hi guys,

 

I hope you are all in good health and that this crisis will end quickly.

My doubt lies in comparing columns in a visualmatrix on the power bi.

 

I have made a matrix like this:

I made several measurements with power query, such average assignments times for a task, for each day

tabela simples.PNG

 

I also have a baseline data. The days are values based on a column called [dias], and the KPIs are a SUM of task durations and divided by the total tasks with appointment, tasks without appointment and total tasks count. Now I need to reach, in the same matrix, more columns, equal in number as the number of days, the comparison of the days with the baseline. I need to subtract the KPI information of the days with the baseline, as the following table:

tabela que eu queria.PNG

 

As if "Run 1" and "Run 2" values were my days values. I hope you guys can help me, I have no idea how to make this comparison without two separete tables.

 

Thank you in advance for your help.

 
 
1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

 

From the problem description some computations are done in Power Query. 

Can you upload some data in excel and the output expected for the sample data to OneDrive or Google drive and share the link. It will also be good if you can share the pbix file with vital  data masked 

 

Cheers

 

CheenuSing

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.