Forum Discussion
How to Show a Conditional Column on a Dash Table?
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
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