Hello @brft,
Thank you for reaching out with your query. To switch the legend between department and team in your semantic model referencing a data warehouse in Microsoft Fabric, you typically create a parameter in Power BI Desktop. However, this isn't available with the Direct Lake connection.
Follow these steps to manually create the parameter table by editing the model from Power BI Desktop:
- You can manually create a parameter table in Power BI Desktop. This table will contain the values for the parameters you want to switch between, such as department and team. Ensure that the parameter table has relationships defined with the relevant tables in your semantic model. This will allow you to use the parameter values in your visualizations.
- You can use DAX to create measures that switch between the department and team based on the selected parameter value. For example, you can create a measure that checks the selected parameter value and returns the corresponding field. Update your visuals to use the new measures created with DAX. This will allow you to switch the legend between department and team based on the selected parameter value.
If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.
