And Advanced RLS On Field Parameters

Sometimes it is not too efficient to manually adjust the DAX code of the Field Parameters and create a column for grouping. Let’s say when you have more than 8-10 fields, you are probably better off with some dynamic grouping.

One of the easiest (and probably best) ways to do that is by simply grabbing the source table name and using that in the slicer to guide your report users about where that field is coming from.

In the below video I show you how to do that.

And if you just want to quickly grab the DAX code, there you are:

Dynamic Group =
SUBSTITUTE (
    LEFT (
        Parameter[Parameter Fields],
        SEARCH ( “‘”, Parameter[Parameter Fields], 2 )
    ),
    “‘”,
    “”
)

Let’s master Power BI together!

Roland

🙏Thanks for watching and if you liked this video please hit the 👍 button.

📢 Also be sure to subscribe to the channel so you never miss a new video.

Categories: Tips&Tricks

0 Comments

Leave a Reply

Your email address will not be published.