Forum Discussion

tyagiyash32's avatar
tyagiyash32
Icon for Helper I rankHelper I
7 years ago

Drill down

Hi, 

the data is as shown in image:

so in a barchart on axis as region and country (drill down) & on values it shoud reflect the calculated measure, i.e. M, L1. That drill down easily shows region name>country name> and their respective M & L1 values, but I need to drill down that to lower levels to reflect MS, MG, MLa, M Lo,... so on and same for L1 vakues. Sysdate is the date filter.

 

Need Help

5 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi tyagiyash32 ,

     

    Kindly share your excepted result to me. BTW,Please upload your files to One Drive and share the link here.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    The Ideal appoach would be to select all columns other than the M and L columns and "Unpivot the Other columns" in the Query Editor.  Write a calculated column formula to group each entry in the Attribute column into M or L.  We will then have to rewrite your measure and you will then get your desired visual.

    If you are unable to do this, then share the link from where i can download your PBI file.

    • tyagiyash32's avatar
      tyagiyash32
      Icon for Helper I rankHelper I
      7 years ago

      Hi Ashish,

      thanks for your reply, i actually have taken a similar approach. But the values are coming as infinity when drilled down to lower levels

      • tyagiyash32's avatar
        tyagiyash32
        Icon for Helper I rankHelper I
        7 years ago

        Sorry guys,

         

        I think i send it through my organizational account, can anyone send me an email address or anything, where i can attach the BI file and send.

         

        Regards