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, 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
Solved! Go to Solution.
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
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 |
---|---|
16 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |