Forum Discussion

Ki2024's avatar
Ki2024
Regular Visitor
1 year ago
Solved

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 t...
  • Rupak_bi's avatar
    1 year ago

    OK.
    so here what you can do. Hope you already have different measures for those values. If not then create like below

    Unknown 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.