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

Line graph measures not changing with X axis

Hi, 

 

I am recreating a graph I have made previously in another report, which worked fine and as far as I can tell everything is set up the same way. I have different measures for each of the different TV channels, and am graphing their awareness over time. For some reason my measures are just a straight line, and wont vary with month on the x axis. The measures and month values are both from separate tables, but each has a column of Unique IDs for each respondent (which are often duplicates as respondents could answer for multiple channels). For the channel awareness table theres a column with Unique IDs that pertains to the respondent and response with the tv channels they said they are aware of and the following measure for each channel which I put in the values bucket:

 

% Channel = CALCULATE(DISTINCTCOUNT('A1a Service Awareness'[UNIQUEID]), 'A1a Service Awareness'[Response] = "Channel") / DISTINCTCOUNT('A1a Service Awareness'[UNIQUEID])
 
The month table also has a column of unique ids (there arent duplicates in this one) and then a column for the month that respondent answered in.
 
However, instead of the measures varying from month to month, I just get a line with the percentage for the awarenss over the whole time scale:
 
hayuproblem.PNG
Does anyone have any ideas as to why this might be happening? I've been comparing to the one I did before, and the set and measures are the same, so not sure why its not quite working.
 
Thanks for your help!
1 ACCEPTED SOLUTION

Accepted Solutions
v-cherch-msft Super Contributor
Super Contributor

Re: Line graph measures not changing with X axis

Hi @meg95 

Please try below measure.If it is not your case, please share your sample file for us to check.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.

How to Get Your Question Answered Quickly

% Channel =
CALCULATE (
    DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] ),
    FILTER (
        'A1a Service Awareness',
        'A1a Service Awareness'[Response] = "Channel"
    )
)
    / DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] )

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
v-cherch-msft Super Contributor
Super Contributor

Re: Line graph measures not changing with X axis

Hi @meg95 

Please try below measure.If it is not your case, please share your sample file for us to check.You can upload it to OneDrive and post the link here.Do mask sensitive data before uploading.

How to Get Your Question Answered Quickly

% Channel =
CALCULATE (
    DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] ),
    FILTER (
        'A1a Service Awareness',
        'A1a Service Awareness'[Response] = "Channel"
    )
)
    / DISTINCTCOUNT ( 'A1a Service Awareness'[UNIQUEID] )

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
meg95 Regular Visitor
Regular Visitor

Re: Line graph measures not changing with X axis

Hi @v-cherch-msft ,

 

Thanks for getting back to me (and apologies for the late reply). I've tried your suggestion but unfortunately it has the same result as my original dax formula. I'm wondering if it's potentially to do with my model relationships? The line graph takes data from a table, Period, that has a unique ID for every row, and whether they responded during that month, and is filtered to only show rows that responded. The channel data comes from another table with the same unique IDs and whether they responded for channels (also filtered to only be rows that responded). 

 

However, when filtered (by columns in the demographics and filters table) the value shown in the graph doesnt change. Furthermore, you can see in the picture below, that for that set of filters, there are only 3 periods available, however all still show on the x axis.

 

So, I'm not sure what might be causing the problems, as I've been triple checking everything and can't see what the issue is.

 

graph problem.PNGgraph problem 2.PNG

 

Apologies for not being able to share the data, its for a client. 

 

Thanks very much for your help!

 

 

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 424 members 4,296 guests
Please welcome our newest community members: