Forum Discussion
How to Show a Conditional Column on a Dash Table?
Hello, guys! How are you doing?
I have a single report for many different clients (we separate them by clientID on Embedded).
So, there is a client who needs to see a column called "CostCenter" in a table, but he is the only one who needs to see it.
There is a way to show this coloumn just for him? I mean, I don't want a empty column for other clients.
Thank you for your help! ;D
HI smartcompany,
Perhaps you can configure a custom replace function in the query editor and use parameters to control when to replace these field values to blank.
Solved: Replace value in Power Query based on condition - Microsoft Power BI Community
#"Replaced Value" = Table.ReplaceValue(#"Changed Type",each [Column],each if parameter= true then "" else [Column],Replacer.ReplaceText,{"Column"})Regards,
Xiaoxin Sheng
3 Replies
Hi smartcompany,
Did you mean the object-level security? If that is the case, please refer to the following document to know more about this feature:
Regards,
Xiaoxin Sheng
Hello! Thank you for your answer!
But, actually, I'm not talking abaout OLS. As I said, we use Power BI Embedded and OLS dosen't work with that (as far as I know).
I need something like a conditional filter. For example: If clientID has "hasCostCenter" (boolean value), then show this column on a table in dashboard.
HI smartcompany,
Perhaps you can configure a custom replace function in the query editor and use parameters to control when to replace these field values to blank.
Solved: Replace value in Power Query based on condition - Microsoft Power BI Community
#"Replaced Value" = Table.ReplaceValue(#"Changed Type",each [Column],each if parameter= true then "" else [Column],Replacer.ReplaceText,{"Column"})Regards,
Xiaoxin Sheng
