cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EnochS Regular Visitor
Regular Visitor

Line Chart Glitch

Hello,

 

For some reason my report is glitching out i'm not sure what to do about it.. One of the random dates is out of place..

Ratio Report Glitch.JPG

 

 If you can help me figure this one out, it would be much appreciated..

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Line Chart Glitch

@EnochS

Hi, maybe change Week to Type Number instead of Text




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

6 REPLIES 6
CahabaData New Contributor
New Contributor

Re: Line Chart Glitch

I see the data in the (CC) column/field becomes blank....  I think that may be your issue

www.CahabaData.com
EnochS Regular Visitor
Regular Visitor

Re: Line Chart Glitch

@CahabaData,

 

Thanks for the post. Unfortunately, I need this to be a null value since there is nothing written yet. The thing is, it was working fine earlier. Before, the "Date" field would not allow me to switch to a hierarchy field until i saved it and restarted the application. But then this happened.. 

 

When I press "Sort By Goal" it is fixed, but only works properly when the graph is in reverse order..

 

 

 

Ratio Report Glitch 2.jpg

 

 

 

 

CahabaData New Contributor
New Contributor

Re: Line Chart Glitch

if 0, rather than null, would result in the correct visual - - you don't have to make the change permanent to the original column.  You can create a measure or a new calculated column just for the purpose to use it in the visual without contaminating the actual column/field itself.....

 

this is working at the data level

 

since you note that it worked before but not currently - -check out the visual level design options - as I don't have desktop opened at the moment I'm not sure - but in your visual design pane on right side - check the options for that field - possibly there is an ability at the visual level to deal with nulls differently.....

www.CahabaData.com
EnochS Regular Visitor
Regular Visitor

Re: Line Chart Glitch

Its working now.. for some reason...

 

I just added an index number to it, which i've done before already with the same issue, and then this time it decided to work..

 

Seems like either bad design on my part or a software glitch...

Ratio Report Glitch fixed.JPG

 

 

 

BUT.. now the bottom X-Axis Labels do not concatinate the year like before.. It's not really as much of an issue if the graph is correct... although it would be nice to have this glitched resolved.. 

Vvelarde Super Contributor
Super Contributor

Re: Line Chart Glitch

@EnochS

Hi, maybe change Week to Type Number instead of Text




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

EnochS Regular Visitor
Regular Visitor

Re: Line Chart Glitch

@Vvelarde,

 

Thanks. It seems to be resolved now.

 

Thanks for contributing as well @CahabaData.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)