Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MJB2017
Frequent Visitor

Separation of filters for graphs on same page

Hi All,

 

I'm very new to Power BI, and am building my first report template, which I will use for our Senior Management meetings. Given what I've seen from the videos, and from what I've read on the website, I'm super excited to be using this tool. 

 

Currently I'm trying to filter a graph, which is showing the delivery of items for a new operation. I want the graph to show:

 

A) Delivery of items (MTD) (%)

B) Previously forecasted delivery of items MTD (%)

C) Forecast for delivery items  till years end (%)

 

I have 3 columns uploaded to the database showing the accumulation of these numbers, but C) is being hindered because I am setting a filter to limit dates to the end of July, which is in turn effecting the graph for C). 

 

Is there a way to seperate a filter so it only effects one graph, or is there a way to show all 3 lines on the graph, where lines A) & B) cut off in July, but line C) cuts off at another predesigned date?

 

To give an example of how this was uploaded to my app from excel:

 

Del DateForecasted Line Item (MTD)Forecast MTD %Forecasted Line Item (TTL)Forecast % Line Item Delivered (TTL)Line Item %
8/19/201610.01%10.01%10.01%
8/29/201610.02%10.02%10.02%
8/29/201610.04%10.04%10.04%
8/29/201610.05%10.05%10.05%
8/29/201610.06%10.06%10.06%
8/29/201610.07%10.07%10.07%
9/1/201610.09%10.09%10.09%
9/1/201610.10%10.10%10.10%
9/1/201610.11%10.11%10.11%
9/1/201610.12%10.12%10.12%
9/1/201610.14%10.14%10.14%

 

Would really appreciate the help on this! 

 

Cheers,

 

M

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @MJB2017,

 

 

>>Is there a way to seperate a filter so it only effects one graph,

You can open the interaction layout to manage these filter effect.

5.PNG

 

In addition, I try to turn on the forecast feature to enable on your data, but power bi notice me these data are too irregular to analysis forecast data.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft,

 

Thanks for your quick reply! What about if i wanted to combine two sets of information on a graph, but limit the dates of one set of data?

 

For example, I have a MTD Actual, which I want to put on the forecast for the year. 

 

FORECAST would show Jan - December

 

MTD Actual should show Jan - July; but on my chart it continues to run at a flat line all the way to the end of the year. Currently I have this set as MAX on values, in order to show the overall % per month, but it obviously runs flat after July becuase there is no data yet.

 

I think this might be the easiest solution. Do you have any input on this?

 

Cheers!

 

M

Hi @MJB2017,

 

>>MTD Actual should show Jan - July; but on my chart it continues to run at a flat line all the way to the end of the year. Currently I have this set as MAX on values, in order to show the overall % per month, but it obviously runs flat after July becuase there is no data yet.

Forecast can support on this scenario, you should modify your date to let it more regular to analysis. For instance, date interval modify to hourly,daily, weekly, monthly....

8.PNG

 

 

Regard,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.