Forum Discussion

JP8991's avatar
JP8991
Kudo Commander
4 years ago

Slicer with Ragged Hierarchy

Hello,

I am trying to to deal with a ragged hierarchy using a drop down slicer.

What I am trying to achieve is for the chevron to only appear when there is something in the last part of the hierarchy. I am aware that there is a third party slicer that can do something similar to this however they do not have the option for it to be a drop down which it has to be.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("3VdNa8MwDP0rJeeCJTmf5w1222WnEXqbB4XQQpft98+pZagbWTQZY2WnNDxLlp5e7Ne+Lx73X+5jdG/FtigNkiGAxv8+fA5Dsdv2xcPx5Py7BYPgQUzA5+O4eXXj5sWN43DOgQbQL6NayIEYNsBK2sBAM8v/dHLu8L53w5SaWs4N08v0WF4CkYEyWwKESGzX90gd5+huBm/cIOWiNtDGTOfHinG0PA5p3mgvyFZK9S3hvKW0Vt81zeYWKYlzx0wR2Qr9KIMixchOkRo2XHO1kN/rnVs5OdQ5AfisVVYcqCmnUZhA5bv1jeYF78Ogy4EEDJZLwZLpkTD5HPkxKMv1lpFMzM47ScVQcnIKAqYkuZ+pzcnQ8rxFJhRM/jTTojg+LSpZwnMgDCtQPlKtnkRewnVWLC6xB2TWJWK0QA2jKAKSA5tsYKnQrQbGb1ZS1nQSYJYA0CZ8d6Cm47sDtYndXbH/HrzwkOtT6x/aH4AYPcDiY0GPVM+MX9pz7em3FtNLrRQGpvs465GwZAEpzk1zm94mhJ0lD1Grlib0KroorR2MRkl04DVbPuWaB+lPT7Ik8T7XHVvkC1Os3PIVLfo/0Rgx2DEfUld+y6BEyHaF7PrFkiveVyGlUcJt9NFiU5ouNQEgrbU6k4Gq08jdNw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Segmentation = _t, #"Open Date" = _t, #"Greenfield Year" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Segmentation", type text}, {"Open Date", type date}, {"Greenfield Year", Int64.Type}})
in
    #"Changed Type"

 
Thanks in advance.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI JP8991 

    Conditional Chevron is not possible with this slicer visual.

     

    • JP8991's avatar
      JP8991
      Kudo Commander

      Anonymous natively yes, however I have read quite a bit regarding people getting around this with DAX so would like some help.