Forum Discussion
Merging table visuals with different filters for each row
Hi
I'm new to Power Bi and wondered if there was a way to combine multiple table visuals into a single tabulation. Each of my current table visuals have different filters. I have about 20 filtered tables that I want to combine in one overall tabulation.
Currently have:
Table 1 Unknown DoB
| People |
| 45 |
Table 2 Unknown postcode
| People |
| 56 |
And I would like the following table:
| Query | People |
| Unknown DoB | 45 |
| Unknown Postcode | 56 |
Thanks!
OK.
so here what you can do. Hope you already have different measures for those values. If not then create like belowUnknown DoB Measure = calculate(count(table, person ID), DoB=blank())
Unknown Postcode Measure = calculate(count(table, person ID), post code=blank())
and so on.Now you need to create a table named Query from Tab>enter data, put column name as Query and then enter all those caregories like "Unknown DoB","Unknown Postcode" ...... in that column and then load.
finally create a measure to switch
tabular values measure=switch(true(),
max(Query,Query)="Unknown DoB", Unknown DoB Measure,
max(Query,Query)="Unknown Postcode",Unknown Postcode Measure)
now create matrix , put the Query column in the row and the tabular values measure in the value pane. you will get the desired output.
5 Replies
It is a single data table eg:
Person ID DoB Postcode 1 1.1.23
HD23 2 HG3 3 1.2.23 SJ4 4 5.6.23 5 HS4 6 5.4.25 BH3 7 SE4 8 DO8 9 5.8.14 This is basic example of the table visualisations, some of my table visualisations have filters from multiple columns.
Thanks 🙂
- Rupak_bi
Super User
OK.
so here what you can do. Hope you already have different measures for those values. If not then create like belowUnknown DoB Measure = calculate(count(table, person ID), DoB=blank())
Unknown Postcode Measure = calculate(count(table, person ID), post code=blank())
and so on.Now you need to create a table named Query from Tab>enter data, put column name as Query and then enter all those caregories like "Unknown DoB","Unknown Postcode" ...... in that column and then load.
finally create a measure to switch
tabular values measure=switch(true(),
max(Query,Query)="Unknown DoB", Unknown DoB Measure,
max(Query,Query)="Unknown Postcode",Unknown Postcode Measure)
now create matrix , put the Query column in the row and the tabular values measure in the value pane. you will get the desired output.
Thanks so much. I'll try it out 🙂
