cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirupamroy Frequent Visitor
Frequent Visitor

Exclude Internal Traffic from Total Traffic

Hi

 

I need a small help in resolving a problem I am facing. I am creating a power BI dashboard where a column chart is being prepared based on "visits". By default the "visits" number has both internal and external traffic. So I would like to provide a slicer where when required on selection of "Excluding Internal", the total traffic deducts the internal traffic and the column chart is adjusted accordingly based on the selection.

 

Any idea how to do that?

 

Thanks

Roy

4 REPLIES 4
Super User
Super User

Re: Exclude Internal Traffic from Total Traffic

Hi @nirupamroy ,

 

Can you share some more information about your model and the data. Can you provide some sample data?

 

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

 

Regards,

MFelix



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

Proud to be a Datanaut!




Community Support Team
Community Support Team

Re: Exclude Internal Traffic from Total Traffic

@nirupamroy ,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/bypass-a-slicer/m-p/575318#M271857

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
nirupamroy Frequent Visitor
Frequent Visitor

Re: Exclude Internal Traffic from Total Traffic

Hi

 

Answering to your reply. You can see from the table below that "Visits" column includes traffic from both internal and external. So when I plot a column chart for every month, by default the Visits is getting summed up. For example, for the month of April total visits becomes 48. Whereas it should be 40 since internal traffic already included within the number 40. So the column chart should display 40 for the month of April and at the same time, if I add a slicer, where users are given the option to filter "exclude internal traffic", which when selected, the column chart should display 32 for the month of April 2019.

 

DateVisitsTraffic
2019/04/0140Including Internal
2019/05/01257Including Internal
2019/06/010Including Internal
2019/07/010Including Internal
2019/08/010Including Internal
2019/09/010Including Internal
2019/10/010Including Internal
2019/11/010Including Internal
2019/12/010Including Internal
2019/04/018Excluding Internal
2019/05/0158Excluding Internal
2019/06/010Excluding Internal
2019/07/010Excluding Internal
2019/08/010Excluding Internal
2019/09/010Excluding Internal
2019/10/010Excluding Internal
2019/11/010Excluding Internal
2019/12/010Excluding Internal
Anonymous
Not applicable

Re: Exclude Internal Traffic from Total Traffic

Create a new calculated value called External traffic and make sure it does 40-8.

 

Then use Including Internal and External for slicer options.

Helpful resources

Announcements
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.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 183 members 2,045 guests
Please welcome our newest community members: