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
nirupamroy
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
v-chuncz-msft
Community Support
Community Support

@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.
MFelix
Super User
Super User

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


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



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

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