cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Disable concatenate x axis is not working in April version of PowerBi

I have just upgraded to April version and in this version it seems that disable concatenate X axis is not woorking. Is that something I've missed - or is this a bug?

 

2018-04-16_10-35-13.gif

16 REPLIES 16
Highlighted
Helper II
Helper II

Disable Concatenate X-axis is not working in April version

I have just upgraded to april version of PowerBi - but in this version the disable of concatenate X axis does not seem to work. 

 

Is this correct?

 

2018-04-16_10-35-13.gif

Highlighted
Community Support
Community Support

Re: Disable Concatenate X-axis is not working in April version

Hi Fia123,

 

I have upgrade to the lastest version but it works well on my side like below, please check if "concatenate label" works in other visual or other data.

Capture.PNG2.PNG 

 

Regards,

Jimmy Tao

Highlighted
Helper II
Helper II

Re: Disable Concatenate X-axis is not working in April version

Hi Jimmy, thank you very much for your answer.

 

This is very strange. I have tried with a lot of examples and non of them are working on my side. If I change a visual created it the mars version, eg replace a measure with another one, it will be wrong.

 

Here is an another example. The visual on the the top  is created in mars version. The visual on the bottom  is a copy of the one on the top, but here I have remove one of the measure.

 

2018-04-23_22-13-10.gif2018-04-23_22-13-42.gifAny tips???

 

Tove

Highlighted
Helper II
Helper II

Re: Disable concatenate x axis is not working in April version of PowerBi

Hi again,

 

I have made a small example based on a litle Excel file, see below. 

 

Excel file - Table Sheet1Excel file - Table Sheet1

Table CalendarTable Calendar

 

 

 

Highlighted
Helper II
Helper II

Re: Disable concatenate x axis is not working in April version of PowerBi

Hi again,

 

I have made a small example based on a litle Excel file, see below. 

 

Excel file - Table Sheet1Excel file - Table Sheet1

Table CalendarTable Calendar

 VisualVisual

 Concatenate Off is not workingConcatenate Off is not working

 

I hope you , or someone else, can help me to solve this problem. It starting to be a big problem for me since I am a consultant and must go on 🙂 In the the time of writing I consider to unstall the April version and reinstall the Mars version.

 

Best regards

Tove Fjeldvig

Highlighted
Helper II
Helper II

Re: Disable Concatenate X-axis is not working in April version

Hi Jimmy.,

 

I to had to reinstalled the Feb version og Power Bi to get it work. First I try with the Mars version, but it didn't work in this version either. The picture below is from the Feb version

 

2018-04-24_08-27-09.gif   

 

Tove

Highlighted
Community Support
Community Support

Re: Disable Concatenate X-axis is not working in April version

Hi Fia123,

 

I  still can't reproduce your issue. For troubleshooting, could you please share some sample data to me?

 

Regards,

Jimmy Tao

Highlighted
Helper II
Helper II

Re: Disable Concatenate X-axis is not working in April version

Hi Jimmy

 

Tank yoy very much for spending time on this. Here is the link to my litle test example

 

https://www.dropbox.com/sh/le0az2edi8cx8mh/AACH11ibCV20V0SkemeD0pKRa?dl=0

 

Tove

Highlighted
Community Support
Community Support

Re: Disable Concatenate X-axis is not working in April version

Hi Fia123,

 

Your calculate table is:

CALENDAR = ADDCOLUMNS(CALENDAR(DATE(2018,1,1),Date(2018,12,31)),
"Year",YEAR([Date]),
"Month",MONTH([Date]),
"Week", WEEKDAY ( [Date] ))

So in your "CALENDAR" table, you have added three custom columns, right? These columns can't contruct a hirerachy structure with the date created by calender() function. So chart can't recoginze these columns as a hirerachy structure. It you delete the three custom columns, "concatenate" works well. 

 

Regards,

Jimmy Tao

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors