How To Create Horizontal Parameter Selection With Radio Buttons

Date de publication : 05 Nov 2020
Date de dernière modification : 16 Jun 2023

Question

Horizontal parameter selection with radio buttons.

Environnement

Tableau Desktop

Réponse

1. Create a parameter
User-added image

2. Create measure for sales value for different categories like below

Furniture Sales:
IF [Category]="Furniture" then [Sales] end

Office Supplies Sales
IF [Category]="Office Supplies" then [Sales] end

Technology Sales
IF [Category]="Technology" then [Sales] end

Value:

CASE [Parameter 2] when "Furniture" then [Furniture sales] when "Office Supplies" then [Office Supplies] when "Technology" then [Technology Sales] end

User-added image

3. Now for horizontal radio button options for category, place category on columns, uncheck header

Shape radio button
STR([Parameter 2]=[Category])+[Category]

Category on Text, Shape radio button on shape and view as entire view
User-added image

4. This will give true [Parameter 2]=[Category] on the selection so Shape radio button will give t+CategoryName as result

Create a custom pallet for radio button selected shape and unselected

Click on Shape -> assign radio button selected to the ones that start with t and category name and unselected to f and category name.

User-added image

5. Click show parameter toggle between values and repeat the allocation process like above for the shapes

Add the sheets to dashboard

6. Click on Dashboard -> actions _> change parameter values
User-added image