Dynamic Dropdown Navigation (Power BI Tutorial)

Описание: I have already done a video/post on how to implement a static drop down navigation, so in this tutorial I will cover how to implement a dropdown navigation where options are dynamically populated based on the identity of the user.

The steps are the following:
1. Create the Navigation table that will contain all of the pages available to navigate to
2. Create a mapping table that will specify which pages are available to which user
3. Create a Row Level Security rule to apply DAX filter on the Navigation table to dynamically filter pages that the user is not supposed to see

Link to blog post: https://businessintelligist.com/2021/...