How to get the dropdown orientation slicer setting style option for json theme

[andy808]

Hey there, with the new slicer settings - does anyone have the json file term to get the "dropdown" orientation (vs "vertical")?

Thanks!

[v-yangliu-msft · Accepted solution]

Hi  @andy808 ,

After you click 'reset to default' in the format pane, you can try the following Json:

{

"name": "Custom Theme",

         "visualStyles": {

                 "slicer": {

              "*": {

                "data": [{

                                            "mode": "Dropdown"

                                                    }]

              }

        }

    }

}

There are also some related values：

• "VerticalList"
• "HorizontalList"
• "Between"
• "Before"
• "After"
• "Basic"
• "Dropdown"
• "Relative"
• "Single"
• "RelativeTime"

This is the related document, you can view this content:

Raporttiteemojen käyttäminen Power BI Desktopissa - Power BI | Microsoft Learn

Re: json Dropdown and basicShape functions fail - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andy808]

I have another challenge.

I created 2 measures:

# of Paid Days = CALCULATE(DISTINCTCOUNT(ASTimeEntry[TimeRecordedOnDate]),(FILTER('Date Table','Date Table'[IsWeekend] = False ))) + 0

Sum of Tracked Hours = SUM(ASTimeEntry[TrackedHours]) +0

To get a %, divided them:

Total Paid Hours % = [Sum of Tracked Hours] / [Total Paid Hours]

When I slice for 1 person it works (eg 100%). When I use it for the whole team (5 people) - it ADDS the %s (eg 500%). How do I average this %? Average FXN doesnt work, divide FXN by # of people doesnt work. Or is there a completely different formula I need to create?  HELP!

[v-yangliu-msft · Accepted solution]

Hi  @andy808 ,

After you click 'reset to default' in the format pane, you can try the following Json:

{

"name": "Custom Theme",

         "visualStyles": {

                 "slicer": {

              "*": {

                "data": [{

                                            "mode": "Dropdown"

                                                    }]

              }

        }

    }

}

There are also some related values：

• "VerticalList"
• "HorizontalList"
• "Between"
• "Before"
• "After"
• "Basic"
• "Dropdown"
• "Relative"
• "Single"
• "RelativeTime"

This is the related document, you can view this content:

Raporttiteemojen käyttäminen Power BI Desktopissa - Power BI | Microsoft Learn

Re: json Dropdown and basicShape functions fail - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yangliu-msft ,  Do you know of a way it can be set up without having to select "reset to default"  seems kind of cumbersome for end users.  Thanks

[andy808 · Accepted solution]

Liu, amazing! I have been searching and searching for an answer and this worked!!

Thank you so much!!!