Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to filter different tables which gets data from different data sources which doesn't have any relatiuonship. User will give the input in Slicer visual. From the selected value, I need to do some DAX expression and filter out the table visuals.
For Eg. Consider slicer has different dates and other tables has date column but none of the columns interlinked.
In that user will select 2 dates, According to that other visuals should get input from slicer and filter the tables.
In Qlikview, they use some Set Analysis function to get input from visuals. I want to make sure Power BI can support the same or not.
Solved! Go to Solution.
Hi @Nareshbaabu,
The scenario is supported in Power BI. You can simply create a measure, and use it to apply a visual level filter(Count of Rows is greater than 0) on your table visuals. The formula(DAX) should be similar like below.
Count of Rows = VAR minDate = MIN ( 'Date'[Date] ) VAR maxDate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, ( Table1[Date] <= maxDate && Table1[Date] >= minDate ) ) )
In addition, here is a similar thread for your reference.
Regards
Hi @Nareshbaabu,
The scenario is supported in Power BI. You can simply create a measure, and use it to apply a visual level filter(Count of Rows is greater than 0) on your table visuals. The formula(DAX) should be similar like below.
Count of Rows = VAR minDate = MIN ( 'Date'[Date] ) VAR maxDate = MAX ( 'Date'[Date] ) RETURN CALCULATE ( COUNTROWS ( Table1 ), FILTER ( Table1, ( Table1[Date] <= maxDate && Table1[Date] >= minDate ) ) )
In addition, here is a similar thread for your reference.
Regards
Hi @Nareshbaabu,
Great to help! If the solution works, could you accept it as solution to close this thread?
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |