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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
justindoh
Frequent Visitor

How to show filter on dashboard

I am new to Power BI.

I came from Tableau background, and I am trying to find a way to have a filter located within Dashboard.

I searched online for help, but I am not finding a solution.

For Report, filter stays within Filter pane.

What about Dashboard?

Is there a way to show filter?

 

Thanks.

Justin

3 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@justindoh , In a report(one that is created on desktop) you can add slicer from visualization)

https://data-flair.training/blogs/power-bi-slicer/

You also have filter pane.

 

In the power bi service, you can create a dashbaord. In the dashboard, you can only have a slicer if you put the complete report on a dashbaord.

View solution in original post

aj1973
Community Champion
Community Champion

Hi @justindoh 

unlike reports in the service Dahsboards do not support filters, check out the difference

aj1973_0-1617915725797.png

 

  

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

aj1973
Community Champion
Community Champion

@justindoh 

Yes and no, it depends on how many reports you would like to combine. Combining too many reports is not a good approach. you can also use Bookmarks and Drillthrough to navigate between pages inside one report. Check out my report here

https://app.powerbi.com/view?r=eyJrIjoiMmFhYWVlMDUtYTk3My00Y2U2LTgwMWEtZDQwNjAyNmQwNjc5IiwidCI6IjgzN...

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

5 REPLIES 5
aj1973
Community Champion
Community Champion

Hi @justindoh 

unlike reports in the service Dahsboards do not support filters, check out the difference

aj1973_0-1617915725797.png

 

  

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 

Thank you for your help.

So, it is better to put slicer/slicers into one report with other visuals rather than trying to combine multiple reports with slicer(s), correct?

I guess I am not sure the difference between Report and Dashboard is. All got mixed up.

I thought Dashboard is the final product with filters (like in Tableau), but it appears that Report is more user friendly (with slicers). Am I correct, or no?

aj1973
Community Champion
Community Champion

@justindoh 

Yes and no, it depends on how many reports you would like to combine. Combining too many reports is not a good approach. you can also use Bookmarks and Drillthrough to navigate between pages inside one report. Check out my report here

https://app.powerbi.com/view?r=eyJrIjoiMmFhYWVlMDUtYTk3My00Y2U2LTgwMWEtZDQwNjAyNmQwNjc5IiwidCI6IjgzN...

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

justindoh
Frequent Visitor

@amitchandak

Thanks for your support.

So, I was able to add a slicer into a report where it has 4 visuals (1 slicer and 3 other visuals without slicer) all together. 

My initial approach was creating each report separately and PIN them, and also I was trying trying to pin the slicer (that was my first logic). But, I guess Power PI was not developed that way.

My next questions are:

1) In order to use slicer/slicers, do other visuals have to stay within a same report all the time?

Is there way for multiple reports (I guess I need to pin) to be used in dashboard with separate visuals in different reports?

2) What is best practice as far as slicing data (one slicer/multiple slicers/Filers pane)?

 

Thanks.

Justin

 

amitchandak
Super User
Super User

@justindoh , In a report(one that is created on desktop) you can add slicer from visualization)

https://data-flair.training/blogs/power-bi-slicer/

You also have filter pane.

 

In the power bi service, you can create a dashbaord. In the dashboard, you can only have a slicer if you put the complete report on a dashbaord.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors