The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all,
I have two seperate visualization tables on my report and would like to have a summary section which shows the data selected on the table. Eg:
Table 1 consist of active task
Table 2 consist of pending task.
When select row 1 on active task(Table 1), text dynamically change based on the data in the table.
When select row 1 on pending task(Table 2), text dynamically change based on the data in the table overwriting the text initially generated by selected active task.
Is this possible by using DAX measures with variables?
I planned not to combined both the tables because there are some subtask tracking need to be done for pending task whereas active task is just a simple table showing when it's completed. So I kept the tables separated.
@parvin006 , Two tables can interact but can not work as slicers. In the case of slicer, the filter remains after selection unless reset.
But in visual, it reset when clicking on another value or double click, You use control to select multiple values.
what exactly you want is not clear
refer, if needed
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
User | Count |
---|---|
24 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
29 | |
13 | |
11 | |
9 | |
9 |