Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

How to Get Your Question Answered Quickly

Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
miguelcontreras's avatar
miguelcontreras
Icon for Advocate I rankAdvocate I
5 years ago

I am using the waterfall chart and I need my measure to change depending on the level of exploration in the chart, does anyone know how I could know the level, for example if I put a date hierarchy as a category, I would like if I am at the years level, months or quarters, etc.

 

Thanks

  • miguelcontreras's avatar
    miguelcontreras
    Icon for Advocate I rankAdvocate I
    5 years ago

    I found the solution with this measure:

    % Variacion Rotacion =
    SWITCH(SELECTEDVALUE(Calendario[Fecha].[Mes]),
    "enero",[% Variacion Mensual],
    "febrero",[% Variacion Mensual],
    "marzo",[% Variacion Mensual],
    "abril",[% Variacion Mensual],
    "mayo",[% Variacion Mensual],
    "junio",[% Variacion Mensual],
    "julio",[% Variacion Mensual],
    "agosto",[% Variacion Mensual],
    "septiembre",[% Variacion Mensual],
    "octubre",[% Variacion Mensual],
    "noviembre",[% Variacion Mensual],
    "diciembre",[% Variacion Mensual],
    [% Variacion Anual])
  • dataflip's avatar
    dataflip
    Icon for Kudo Kingpin rankKudo Kingpin
    1 year ago

    Thanks for sharing