Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Creating Dynamic table visual based on another table visual

Hi Team, I have three tables in Power BI (Country, State and Category) and based on these three tables, I have three slicers in my power bi report  and two table visuals. I have two table visuals al...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
This is possible only using start schema data model plus some modifications. A factTable need to be introduced having the Country Name and State Name columns (that will be used in the 2nd table). Please refer to attached sample file for more details.

FilterMeasure = INT (  ISEMPTY ( FactTable ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for the reply. But In this solution, I need the filter criteria of Country and State to be applied in both visuals. If Country 1 is not selected, then it should not be present in two visuals. 

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Anonymous 
      Not sure if I fully understand. However, please check new proposed solution as per attached sample file.

      FilterMeasure = INT (  ISEMPTY ( Category ) && NOT ISEMPTY ( State ) )