cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 🙂

I can see that it works well with the "Date hiearchy" automatically created by PowerBi, but it doesn't  work with the  data hiearchy I have made by myself. This must be something new?? I have created a lot of reports where "non-concatenate" works very well with customized columns, but if I "touch" the graph with a version of PowerBi after Feb 2018, it doesn't work anymore. See example below.

 

I can live with this, but I need to add week no to graph and replace month name with month no. How do I change the data hiearchy created by PowerBi???

(I look forward to upgrade PowerBi again)

 

2018-05-03_21-07-07.gif

 

 

https://www.dropbox.com/s/4y1q6blwmz81jjd/Feb2018_Concatenate.pbix?dl=0

 

Tove

Highlighted
Helper II
Helper II

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

Hi,

Here's is another example where "non-concatenate" doesn't work anymore. This example has nothing to do with dates.

In the first picture the chart is made by Feb 2018 version of PowerBi - and the next two by April version.

 

This must be a bug??? 

 

2018-05-04_11-49-30.gif2018-05-04_11-52-00.gif2018-05-04_11-51-30.gif

 

 

Tove

Highlighted
Helper I
Helper I

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

I have the same problem as Fia123.

 

Using the data below I am unable to disable concat on the x-axis.

Main groupSub groupValue
Aaa1
Aaaa2
Bbb3
Bbbb4
Ccc5
Cccc6

 

Even though concatenate is set to Off it remains the same and it doesnt helpt to use Main Group-hierarchy instead of the groups as they are.

 

concat broken.PNG

 

chart setup.PNG

 

I am as well on the April 2018 version.

 

about pbi.PNG

 

I guess this might be an unrelated issue, but trying to mitigate this by updating to the May Version I get the following error:

error pbi.PNG

Highlighted
Post Prodigy
Post Prodigy

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

I posted an issue about this, it has beening going on since at least 2017 😞

 

https://community.powerbi.com/t5/Issues/concatenate-Labels-does-not-work-properly/idc-p/415565

 

 

Highlighted
Helper II
Helper II

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

The problem is solved 🙂

 

If you still have the the problem, sort the graph of diffrent criteria (press a bit back and forth), then it will work .

 

Tove

 

Highlighted
Advocate III
Advocate III

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

Thank you Fia123, this has been the most helpful answer for me.  I could not understand why it would work for some fields and not others... now I know. 

Highlighted
Regular Visitor

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

Hi, in case, If you haven't found it:

Here is the answer

(Quick Tip: Please ensure how the chart is sorted by x axis)

 

Best Luck!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

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