Dynamically change visual value based on slicer value selection

In Power BI, You can change the visual value dynamically based on slicer value selection.

Requirement-

Suppose you have three measures – Sales, Profit & Discount, and user/ client want to see only selected slicer measure value on visual(one measure value at a time).

Expected output-

Let’s understand how you can be achieve this-

Download the sample Dataset from below link-

• Global Super Store Dataset

Now follow these steps in order to achieve this-

Step-1: Create a static table with measure name.

Under Home tab > Click on Table icon > table dialogue box opens.

Then Change column header name( double click on header name and enter new name), after that enter measure name row wise, see below screen shot.

Then provides the table name & click on Load button.

Step-2: Now add one slicer visual into report page and drag static table column “Type” into slicer. And set below properties for slicer.

• General: Choose Orientation : Horizontal &Turn on Responsive.
• Selection controls: Turn on Single select
• Selection header: Turn off selection header
• Items: Allows you to set the font size, font family, color & background color for Text.

Step-3: Create a dynamic measure for value change.

Right click on dataset name > New measure > Enter below DAX code.

Total Amount =
VAR TotalSales = SUM ( 'Global-Superstore'[Sales] )
VAR TotalProfit = SUM ( 'Global-Superstore'[Profit] )
VAR TotalDiscount = SUM ( 'Global-Superstore'[Discount] )
VAR SelectMeasure =
SELECTEDVALUE ( Navigation[Type] )
RETURN
IF (SelectMeasure = "Sales",TotalSales,
IF (SelectMeasure = "Profit",TotalProfit,
IF (SelectMeasure = "Discount",TotalDiscount,
BLANK ()
)))

Measure Description:

• Write DAX to get Total Sales, Profit & Discount and store all three calculation into three separate variables.
• Store Slicer selected value into variable “SelectMeasure”, Navigation is Static table name & Type is column name.
• Use IF condition, Passed measure variable name into condition based on selected values.

Step-4: Now add one clustered column chart into report page and drag Region column to Axis & measure to Values section.

Now it will change the visual value dynamically based on slicer selection.

Refer Power BI other post: Power BI tutorials

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.