Forum Discussion

PBI_Developer2's avatar
PBI_Developer2
Frequent Visitor
2 months ago
Solved

Slicer horizontal radio button

Hello community,   Actually I'm working on Migration project to Power BI, so I need to recreate the same layout and design as it was in the previous Solution (Microstrategy).   How can I create a...
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    2 months ago

    Hi PBI_Developer2 

    Migration from one system to another is rarely an apples-to-apples process, so it's important to set that expectation with stakeholders from the start. That said, you could also try using the button slicer with a horizontal layout.

     

Rupa01's avatar
Rupa01
Solution Sage
2 months ago

Hi PBI_Developer2,

The native slicer in Power BI does not support displaying a list-style slicer in a horizontal layout.

As a workaround, you can use a custom visual such as the Chiclet Slicer. This allows the values to be arranged horizontally, although they will behave as tiles rather than a traditional list.

For a cleaner look, you can:

  • Remove the visual title
  • Turn off tile borders
  • Adjust spacing and formatting

This helps achieve a layout where the values appear in a single horizontal row.

It will be displayed as shown below:

 

 

💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
PBI_Developer2's avatar
PBI_Developer2
Frequent Visitor
2 months ago

Hello Rupa01,

 

Thank you but, No, I need to keep the Radio Button, because it is a Migration Project so the Customer needs to have the exact Layout in Power BI that he used to see in Microstrat, so I can not change with Tile or whatever. It should be exactly as the Screenshot I posted in my request.

  • danextian's avatar
    danextian
    Super User
    2 months ago

    Hi PBI_Developer2 

    Migration from one system to another is rarely an apples-to-apples process, so it's important to set that expectation with stakeholders from the start. That said, you could also try using the button slicer with a horizontal layout.

     

  • Rupa01's avatar
    Rupa01
    Solution Sage
    2 months ago

    PBI_Developer2,

    A true horizontal list slicer with radio button circles is not supported in Power BI.

    As a workaround, you can achieve a similar experience by:

    • Using a hidden native slicer (for actual filtering)
    • Creating horizontal buttons (Daily / Monthly)
    • Using bookmarks to control selection
    • Adding Unicode symbols (● / ○) to mimic radio buttons

    This gives a horizontal, single-select, radio-style UI, while retaining slicer functionality.

     

    ✅ Below is an example with steps - 

    1. Create a slicer table (if not available):

    Granularity = DATATABLE( "View", STRING, { {"Daily"}, {"Monthly"} })

     

    2. Add a slicer using Granularity: Turn ON Single select

     

    3. Create a selection measure:

    Selected View = SELECTEDVALUE(Granularity[View], "Daily")

     

    4. Create label measures (radio look):

    Daily Label = IF([Selected View] = "Daily", "● Daily", "○ Daily")
    Monthly Label =IF([Selected View] = "Monthly", "● Monthly", "○ Monthly")

     

    5. Add two buttons (horizontal) and bind text using fx:

    Button 1 → Daily Label
    Button 2 → Monthly Label

     

    6. Create bookmarks:

    Select Daily in slicer → create BM_Daily
    Select Monthly in slicer → create BM_Monthly

    Note: Ensure Slicer is hidden when saving the bookmarks


    7. Assign actions:

    Daily button → BM_Daily
    Monthly button → BM_Monthly

     
    ✅Result: Horizontal, single-select UI with radio-style circles (● / ○) while retaining slicer functionality.

     

    💡 Helpful? Give a Kudos 👍 — keep the community growing
    ✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

    Best regards,
    Rupasree Achari | BI & Fabric Analytics Engineer