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.
Hello!
I'm currently having the following situation:
I have a list of IDs, 20 modules and a count per module.
So I'm creating a table visualization in which there are 20 columns (1 per module), and each row should be the client id, followed by the count per module.
The problem is that not all clients have entries for all modules. And if I click on a client ID, it refilters the columns and shows only columns for which that client has an entry.
So if the client has entries associated with modules 1,2, and 5, if I select it on the table it will resize the table and show only columns 1, 2 and 5, while I want it to keep showing columns 1 to 20 (Empty, for the modules in which the client doesn't have any entries for).
Is there any way of fixing the columns shown at all times? Last case scenario I could try to generate rows with count 0 for the modules missing, but this seems even more complicated.
Anyone knows if I can achieve this visually?
Solved! Go to Solution.
Hi @Anonymous ,
Suppose the source table ('Data_6') is like below.
New a calculated table which is linked to source table.
module dimemsion = VALUES(Data_6[Module])
Insert a Matrix visual. Please note that you should drag [Module] from 'module dimension' table.
Best regards,
Yuliana Gu
Hi @Anonymous ,
Suppose the source table ('Data_6') is like below.
New a calculated table which is linked to source table.
module dimemsion = VALUES(Data_6[Module])
Insert a Matrix visual. Please note that you should drag [Module] from 'module dimension' table.
Best regards,
Yuliana Gu
Thank you!
That solved my issue.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |