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.
Hi experts,
I hope everyone is doing fine.
I am confronting a problem and hoping to get your help.
I have a table in PBIX File, be It any kind of table but supposingly I have two columns displayed in front of me.
I want to filter the table and display only that part in which both the columns will have a value. If any column value is empty,I do not want to display Its corresponsing value as well.
NAME | ADD |
A | ABC |
B | CDE |
C | FGH |
D | ABC |
E | GFH |
F | DKD |
G | EDIE |
H | DHS |
I | SLF |
J | VZK |
K | CDK |
L | CQP |
M | |
K | |
O | |
P | |
Q | |
R | |
S | |
T | |
U | |
V | |
W | |
X | |
Y | |
Z | |
A | |
B | |
C | |
D | |
E | |
F | |
G |
For Example- I want to display the upper values in which both columns have values and remove the lower part of NAMES in which there is no corresponsing value. How Can I do that?
I hope you understood my problem.
Solved! Go to Solution.
Hi @gupta_diksha ,
Did you tried applying a visual level filter on both the columns as shown below ?
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Hi @gupta_diksha ,
Did you tried applying a visual level filter on both the columns as shown below ?
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Thank you very much.
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 |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |