Combine a one month measure with full year one in the same PBI report

Used for anything related to the new Power BI Desktop and Service tools
luiscu
Posts: 2
Joined: Thu Sep 22, 2016 12:08 am

Combine a one month measure with full year one in the same PBI report

Postby luiscu » Thu Sep 22, 2016 4:30 am

Hi,
In a PBI report I need to show a measure calculated for a month selected by the user and at the same time show the evolution of such measure over the year.

Simplified example.
Let's say we have a table of sales by month and a report with three elements/visuals: A slicer to select the month, a measure that shows the sales of the month selected and a graphic that shows the sales over the year.

The problem that I found is that when the user selects the month then the graphic only shows the sales of he month selected. If I all the months ares selected the graphic is OK but the measure no.

Any guess?

Thanks a lot in advance.

Luis

PS: excuse me if the question is trivial. I'm new in DAX and I've tried to find a solution for the forum before posting this Q.

MattAllington
Posts: 932
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Combine a one month measure with full year one in the same PBI report

Postby MattAllington » Fri Sep 23, 2016 1:40 pm

Hi Luis

Read my blog article about filter behaviour (and how to fix your problem) here http://exceleratorbi.com.au/control-cro ... -power-bi/

There is a wealth of information in other blog articles on my site too.
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/

luiscu
Posts: 2
Joined: Thu Sep 22, 2016 12:08 am

Re: Combine a one month measure with full year one in the same PBI report

Postby luiscu » Thu Sep 29, 2016 3:58 am

Lots of thanks Matt, Works fine.
I'm already suscribed to your blog. It is very useful and I strongly recomend it.


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron