Forum Discussion

ims20180411kjb's avatar
ims20180411kjb
Advocate I
5 years ago
Solved

Dual Y-Axis Line Chart Value Disappears when Report is Published

Good afternoon, I am experiencing an issue concerning a Line Chart with 2 Primary Y values and 2 Secondary Y values and months as the X axis as per below:   PY1 - Sales per month Current Year P...
Need Help
  • mdent's avatar
    mdent
    5 years ago

    Hi,

     

    I too are facing similar issues and it is doing my head in. Do you have conditional titles on your visuals? I found that removing that fixed some of my charts. Another aspect that helps was getting the latest build of pbi desktop, as I could see the behaviour then too.

     

    I am currently facing big issues with conditional titles, as of today all have failed after 9 months of working.... Grrr.....

     

    Hope you find the answer to your woes and post the solution if you or Microsoft find it, as I can't work out out ATM.

mdent's avatar
mdent
Frequent Visitor
5 years ago

Hi,

 

I too are facing similar issues and it is doing my head in. Do you have conditional titles on your visuals? I found that removing that fixed some of my charts. Another aspect that helps was getting the latest build of pbi desktop, as I could see the behaviour then too.

 

I am currently facing big issues with conditional titles, as of today all have failed after 9 months of working.... Grrr.....

 

Hope you find the answer to your woes and post the solution if you or Microsoft find it, as I can't work out out ATM.

ims20180411kjb's avatar
ims20180411kjb
Advocate I
5 years ago

Hi mdent,

 

thank you very much for your reply and I can confirm that it was indeed the conditional titles that were causing the issue.

 

Frustratingly, I'd recently incorporated Calculation Groups into this report allowing me to select metric slicer buttons of different types (#,0; £#,0 & %#.0) and have the chart and grid items re-format accordingly.

 

Of all the additional complexity that I added to the report, I did not expect the inclusion of dynamic titles, purley for cosmetics, to completely unseat me this way.

 

I have removed the offending titles for now and have instead opted for simple generic versions - not ideal but not worth me wasting any further time over for now.

 

However, I will revisit when I next get some spare time and will let you know if I'm able to establish a work-around.

 

Either way, I'm really grateful for your response and you've saved me from any further frustration and confusion.

 

Much appreciated and kind regards

 

Karl