cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lorentzt Frequent Visitor
Frequent Visitor

How to present result from two matrixes in a common matrix

I am new to Power BI and are working on moving my old Excel (power pivo) reports to Power BI. Most of that works well, but i have encountered a problem. 

 

I have a montly report of all active support tickets for a customer. (created the 1st in every month for a previous month)

I have a custom column that shows all tickets that was open the last month and it gives me the complete ticket list Smiley Happy

 

On the front page i used to have a table given information on the status at mont start, end and new/closed tickets.frontpage1.PNG

 In PowerBI i manages to get this split into two diferent queries by checking if a ticket was created last month or closed last month. As a ticket both has a created periode and a closed periode i dont see how i can use one column value to split between the rows in the presentation.

 

Created_Last_Month:False = Tickets at start of periode

Created_Last_month:True  = New tickets in periode

Closed_Last_Month: True  =  Closed tickets in periode

Closed_Last_Month: False = Open tickets at periode end.

Created last month.PNGClosed last month.PNG

 

In Power Pivo i solved this by creating two Power Pivo's and then assigned the presentations values by poiting to the diferent cells in the power pivo's.

 

Any ideas, sugestions is very welcome.

2 REPLIES 2
Lorentzt Frequent Visitor
Frequent Visitor

Re: How to present result from two matrixes in a common matrix

Searching the forum i found a post about using Measurement for sorting values and it looked like a possible solution. Sharing the solution and result below for others that may need it Smiley Happy.

 

I created a measurement using countrows and filter for each of:

Start, New, Closed, Remaining.

 

This gave me this promising result:

Frontpage2.PNG

 

So now i had a usable presentation, but i wanted type to be shown as columns so i moved 'Type" fra rows to columns but the result wasnt as wished:

Frontpage3.PNG

 

 

This problem was possible to fix by changing the Values parameter "Show on rows" to true.

Frontpage4.PNG

 

This looks good:

The only challenge now is how can i order the columns in my prefered order?

 

 

 

vanessafvg Super Contributor
Super Contributor

Re: How to present result from two matrixes in a common matrix

@Lorentzt create a new column for the sort order  so depending on what you order you want you can either create a calculated column with a switch statement or manually create it in power query - does that make sense?

 

then in your modelling table in power bi set the sort of that column by the column ie Capture.PNG


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,870 guests
Please welcome our newest community members: