Forum Discussion

TcT85's avatar
TcT85
Helper III
9 months ago
Solved

Filter on table visual

Hi,       I'm using two table visuals (not database tables): Table 1 displays data from all our test equipment for today. Table 2 shows data from the last 30 days. What I want is: when...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    9 months ago

    Hi TcT85, 
    Thanks for the follow-up question.

    I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

    outcome: 

    I am also including .pbix file for your better understanding, please have a look into it.

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

Hi TcT85 ,

the information is bit in complete.but i will try to share the steps.

  1. Create a measure for rowcount or count which will take common column or dimension between 2 tables
  2. then select table 2 and add measure created in step 1 to visual level filter
  3. add condition measure is greater than 0 in visual level filter

Please find sample pbix file for reference.Sampl PBIX 

 

Give kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

TcT85's avatar
TcT85
Helper III
9 months ago

Hi Praful_Potphode 

 

Im not allowed to download any files at work. Sorry for the inconvience.

  • Praful_Potphode's avatar
    Praful_Potphode
    Super User
    9 months ago

    Hi TcT85 ,

     

    try the approach suggested and let me know .

     

    Thanks and Regards,

    Praful