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 r...
Need Help
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

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

      Hi,

      Use Google Drive/One Drive.