Removing duplicate value in hierarchical axis

[Mughees]

Hi,

I am working on a file where there are hierarchical x-axis (Division (large region) and district (region within Division). I am getting the right Clustered column chart but the Division is appearing with all District within its domain i.e. DG Khan is division and appearing three times with the districts present within DG Khan.

All I want is that DG Khan should appear once in x-axis like in picture below. 

I am unable to do it by matrix. I am attaching the power BI file also for reference. Any help would be appreciated.

Below is the link to power BI file.

https://filebin.net/yoceult8p816pnmp 

Regards

[v-eqin-msft · Accepted solution]

Hello @Mughees ,

Make sure that the chart sorts by x-axis values like this:

Have I answered your question? Please mark my answer as a solution. Thanks a lot.
If not, load some insensitive data samples and expected output.

Best regards
Eyelyn Qin

[Mughees]

Thanks alot @Eyelyn9 . I got what I need 🙂

[v-eqin-msft]

Hi @Mughees ,

Sorry ,I have trouble with downloading your pbix file here .

Maybe you could take a look at my pbix here:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/stephent01_qiuyunus_onmicrosoft_com/ETNFDd-JYL5Kky... 

Best regards,

Eyelyn Qin

[Mughees]

HI @v-eqin-msft , 

Thank you for your time but I am still facing the same issue and could not get it done in my own file as @gpiero  mentioned in last comment. 

Below is the link of my file. 

https://filebin.net/g10izdksrrtmf54m

Can you please get it done in my file and tell the trick on how we should do it. I have many other graphs on which I have to apply this thing.

[gpiero]

Hi @Mughees 

your link does not contain any pbix.

May I have your original pbix?  If I can I would like to understand where is the trick🤔

[Mughees]

https://safenote.co/r/5f7ee5eee44011@61226145

Please find above the link

[gpiero]

@Mughees 

sorry, issues in download.

link expired

please share in Onedrive or Dropbox

[Mughees]

https://www.dropbox.com/sh/fw0kh0h7d57gsj7/AAAJfjHBF3dWqmvUe-ZGomg4a?dl=0

Please find above the link

[gpiero]

Hi @v-eqin-msft 

Now I am a bit curious.
It is a very strange thing.

Using your pbix, I have tried to regenerate the same visual on page 2 and I got the same issue by @Mughees , even if when I applied the  concatenate label = off to his first pbix it works.

Is there something else to setup?

I am not able to understand

[v-eqin-msft]

Hi @Mughees ,

Sorry for my late reply... 

From your screenshot, it seems that drill down is used. Please make sure the buttons of Drill-down presents the following state:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[Mughees]

Hi ,

Still the issue is persisting. PFB the image for reference once I tried as you said.

Can you please show me how to do it in my file. I have attached my file in the below link. It would be a great help.

https://gofile.io/d/MX73cr

[v-eqin-msft]

Hi @Mughees ,

Please  disable  Concatenate labels under X-axis tabs like this:

Did I answer your question? Please mark my reply as solution ,thank you.

If you have any questions, please upload some insensitive data samples .

Best Regards,

Eyelyn Qin

[Mughees]

Hi Eyelyn9,

Sorry for late reply. I tried your method as well but it is not working as well. Please see below the image.

It is quite surprising that despite doing the same thing we are not getting the same result. I have the latest POWER BI desktop software. Can you please guide me what is the issue. 

[gpiero]

@Mughees 

Hi,

it is very likely I did not catcht perfectly you requirement.

Could you try to remove the field "division", leaving only DISTRICT?

Please check if it is what are you looking for

Regards

[Mughees]

Hi @gpiero ,

Thank you for your reponse.

All I want is to have both Division and district in X-Axis, but the Division should appear once instead of appearing 3 or 4 times with each of its districts. like below:

Currently it is appearing like below in POWERBI. The first name is x axis is division while second name is district.

I hope it made things a little clear. Please do let me know if still there is confusion.

[gpiero]

@Mughees 

Hi

Did you ty to apply the article below?

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#hierarchicalAxis 

[Mughees]

@gpiero  yes i read it. It is saying the concatenate thing but that is not fixing my issue.