Forum Discussion

andy808's avatar
andy808
Icon for Resolver I rankResolver I
3 years ago
Solved

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

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

 

Thanks!

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      Anonymous ,  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's avatar
      andy808
      Icon for Resolver I rankResolver I
      3 years ago

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

      Thank you so much!!!

  • andy808's avatar
    andy808
    Icon for Resolver I rankResolver I
    3 years ago

    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!