Forum Discussion
Hiding columns if blank
Hello,
I am currently having issues with the following case:
I have a table that groups different types of information, with 40 columns, but each case has values in a different columns. Example:
Type-Col 1_Col 2_Col 3_Col 4
A --- -X-----X----" "----" " -
A --- -X-----X----" "----" "--
B --- -X-----X----" "---- X --
C --- -X ----" "---" "----" " -
D --- " " ----X----" "----X- -
D --- " " ----X----" "----X- -
E --- " " --- " " -- X ----" " -
Meaning X: has data, " " does not have data (a blank). Is it possible in Power BI to construct one table with all colums and, when I filter by Type (A, B, C, D, E), it only shows the columns does contain data?
I have tried by leaving the column with no name, and it would do the tick, but then I don't know which value X it is showing.
Regards,
Antonio
7 Replies
- zoloturu
Memorable Member
Anonymous,
It is not supported in Power BI.
You can also check similar thread - http://community.powerbi.com/t5/Desktop/Conditionally-display-columns-based-on-options-in-report-filters/td-p/39107
- zoloturu
Anonymous,
You can play with R scripting in a way to remove columns (which called variables in R) if first value in column is NULL.
Run R script
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Unfortunately, it is not possible to hide/show column conditionally based on slicer selection. Here is a similar idea, you could click to vote it up.
Regards,
Yuliana Gu
