Table Visual - Update for different Data Set

[Anonymous]

Hello,

I have two data sources loaded into a signle PowerBi report.  I am trying to make a single page report that encompasses all of our Incident and Change Requests.

Currently I have the following data tables with different schemes:

1.  CHange Request

2. Incident Ticket

Below my pie charts I have a Table visual - I want the table to be reflective of which pie chart I click.

Ex.  Open vs Closed Change Pie Chart, and I click Open Requests the table visual updates to what I want to show

Ex 2- Open vs Closed Incident Ticket Pie Chart, and I click Closed Tickets the table visual wont show Incidents at all instead it just filters change request data source.

So is there a way to do what I am looking to do whether native or plugin? 

[v-rzhou-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@Anonymous , I think some screenshot or table is missing.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Here are the screenshots - in the first by default the table in the bottom shows change data which is what I want, in the second when I want to look at the inprogress Incidents it still shows me all the changes.

Change Request Schema:

Incident Table Schema:

[v-rzhou-msft]

Hi @Anonymous 

Did you build any relationship between two tables?

I think you want to filter table visual (build by Change Request Schema) by the column State in Incident Table.

You may try to build a relationship between two tables.

Or you can add a  measure to calculate the value you want by state.

EX:

Measure = calculate(Max(Change Request[Planned Start Date]),filter(Change Request,Change Request[Phase] = max(incident Table[State]))

Or use if/Switch function 

Switch(True(),Max(incident Table[states])= "in progress",resultA,Max(incident Table[states])= "Closed",ResultB,ResultC)

Could you tell me if there are some related between two tables?

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.