Using field parameters in Power BI to dynamically create hierarchies with a single select slicer

Innovative use of field parameters to dynamically change a table into a hierarchical matrix

Photo by Lukas on Pexels

This article is also available at bits 2 BI

The might of field parameters lies in the parameter slicer and the flexible behavior it demonstrates as a user plays with the slicer.

Field parameters work great to change dimensions or create hierarchies with a multi-select slicer. Whereas, using a single select slicer, things don’t work out if you try to build a dynamic matrix (or any other visual with hierarchies).

In this article, we look at an innovative implementation of field parameters to dynamically change hierarchical and non-hierarchical dimensions in a matrix using a single select slicer.

Please read our terms of use before proceeding with this article: https://dhyanintech.medium.com/disclaimer-disclosure-terms-of-use-fb3bfbd1e0e5

Whether developing a new report or updating existing reports, leveraging field parameters is relatively straightforward. In a previous article, we talked about the field parameters and all the amazing things they could do to simplify the life of a Power BI developer and the…