Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Is there a way to create a dynamic table in Power BI using the selected values from a slicer?
If I unpack my question, i need to create a dynamic table which lookups rows from another table and it needs to filter rows by the selected values from a slicer.
Any help will be much appreciated...
Thanks
Hi @darshiw
Calculated Tables are created only once at the load time and therefore can not create based on the slicer value .
However, if you want to build a measure on dynamic table created based on slicer this has to be done within the measure.
If you can put sample dat / pbix file in OneDrive / Google Drive and sshare the link it will help.
Cheers
CheenuSing
Hi CheenuSing,
Thanks for the reply.
I have a data table for all the assignments assigned to each employee. Below is a general sample of data.
For example BR1 is assigned for only 2 PSs (PS1 & PS2).
Also one PS is assigned to several employees. Ex. PS1 is assigned to 4 employees BR1, BR2, BR3 and BR4.
PS ID | ASA ID | Emp ID |
PS1 | ASA1 | BR1 |
PS1 | ASA2 | BR2 |
PS1 | ASA3 | BR3 |
PS1 | ASA4 | BR4 |
PS2 | ASA5 | BR5 |
PS2 | ASA6 | BR1 |
PS2 | ASA7 | BR4 |
PS3 | ASA8 | BR2 |
PS3 | ASA9 | BR6 |
PS3 | ASA10 | BR7 |
I have slicer to select Emp ID. My requirement is, if the user select BR1, the visual should display the records from this table for all the Plans (PSs) associated with BR1. The result should be like below.
PS ID | ASA ID | Emp ID |
PS1 | ASA1 | BR1 |
PS1 | ASA2 | BR2 |
PS1 | ASA3 | BR3 |
PS1 | ASA4 | BR4 |
PS2 | ASA5 | BR5 |
PS2 | ASA6 | BR1 |
PS2 | ASA7 | BR4 |
Hope this makes sense.
Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |