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

Re: Average over time vs. sliced average

I used to have slicers, but I took them off for simplicity/to figure this first issue out, but those columns weren't being used anywhere else.

 

Here's my dashboard: https://msit.powerbi.com/view?r=eyJrIjoiNzA2MDdiODQtZTNhNC00NTNkLWExM2MtNGJhMGY2YWU1ZTRiIiwidCI6Ijcy...

 

Why would the slicers affect the display?

v-ljerr-msft Super Contributor
Super Contributor

Re: Average over time vs. sliced average

Hi @swong,

 

A little weird! So could you share a sample pbix file(with just some sample/mock data) which can reproduce this issue? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. Smiley Happy

 

Regards

swong Regular Visitor
Regular Visitor

Re: Average over time vs. sliced average

Thank you so much! Here's the OneDrive link: https://microsoft-my.sharepoint.com/personal/t-sewong_microsoft_com/_layouts/15/guestaccess.aspx?gue...

 

Let me know if the permissions don't work.

v-ljerr-msft Super Contributor
Super Contributor

Re: Average over time vs. sliced average

Hi @swong,

 

I have reviewed your shared pbix file. And I find that there is no problem with the formula of the measures. Instead of using Date hierarchies as Axis, you should use the Date column itself as Axis, then it will work as expected. Smiley Happy

 

r4.PNG

 

Here is the modified pbix file for your reference. Smiley Happy

 

Regards

swong Regular Visitor
Regular Visitor

Re: Average over time vs. sliced average

Oh I see! Thank you so so much for all of your help! Smiley Happy

swong Regular Visitor
Regular Visitor

Re: Average over time vs. sliced average

I have a follow-up question -- would it be possible to set the "Overall Line" to be the average revenue for a single color, and for the "Individual" line to be the average line for  single account within that color?

 

More broadly, is it possible to have two lines on the same line graph affected by different slicers?

Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Average over time vs. sliced average

Hi @swong,



I have a follow-up question -- would it be possible to set the "Overall Line" to be the average revenue for a single color, and for the "Individual" line to be the average line for  single account within that color?

 

More broadly, is it possible to have two lines on the same line graph affected by different slicers?


Yes, the formula below should work in this scenario. Smiley Happy

 

Overall = CALCULATE(AVERAGE(Sheet1[Revenue]), ALLEXCEPT(Sheet1, Sheet1[Date],Sheet1[Color]))

r6.PNG

 

 

Regards

swong Regular Visitor
Regular Visitor

Re: Average over time vs. sliced average

Hello again!

 

Whe I add date as a slicer for my table, it works fine.

 

However, I'd like to have two line graphs both affected by the same date slicer. I thought to do this by creating and aux table, where each distinct date has a distinct value, the creating a relationship between Date1 of Table1 and the aux table, and a relationship between Date2 of Table2 and the aux table.

 

The slicer based on the aux table's Date column affects both individual lines on my two line graphs, but not the overall line. Is there a way to make this slicer affect all lines?

swong Regular Visitor
Regular Visitor

Re: Average over time vs. sliced average

Hi @v-ljerr-msft,

 

Checking in about this question.

swong Regular Visitor
Regular Visitor

Re: Average over time vs. sliced average

Hi @v-ljerr-msft,

 

Should I post this in a new question?

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 41 members 950 guests
Please welcome our newest community members: