cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vincent2369 Regular Visitor
Regular Visitor

How to GROUP BY parameters in Power BI Report Builder ?

Hello,

 

I have toying arround with Power BI Report Builder and I didn't find that many tutorials about it yet. I tried to make a Parameter (which is essentially a filter at the top of the report page) on top of my matrix to select a supplier and business parameter like that. The thing I'm seeing is it list in the dropdown all the values of my table one after the other regardless if they are the same value or not. I find it a bit anoying because I don't want to see my supplier like 20 times in the dropdown if I have 20 lines in my table for this supplier. I was wondering if there was a way to do a GROUP BY on these Parameter so each distinct value only show once?

6 REPLIES 6
Highlighted
tejaswidmello Established Member
Established Member

Re: How to GROUP BY parameters in Power BI Report Builder ?

Hi @vincent2369 

 

Correct me if I am wrong.

 

Do you want to take out the duplicates from your slicer?

 

Thanks,

Tejaswi

vincent2369 Regular Visitor
Regular Visitor

Re: How to GROUP BY parameters in Power BI Report Builder ?

Hello @tejaswidmello , 

 

Yes I want to remove the dupplicate from my slicers (the dropdown menu you can add to filter your Power BI Report Builder report)!

 

Do you have a solution?

 

 

 

tejaswidmello Established Member
Established Member

Re: How to GROUP BY parameters in Power BI Report Builder ?

Hi @vincent2369 ,

 

I know slicer itself removes the dups when we add the data to it.

 

May be I will have to look at your dataset. Do you mind in sharing?

 

Or else  you can go thru this blog for your reference.

 

https://community.powerbi.com/t5/Desktop/Removing-Values-from-Slicers/td-p/370928

 

Thanks,

Tejaswi

vincent2369 Regular Visitor
Regular Visitor

Re: How to GROUP BY parameters in Power BI Report Builder ?

Here is my dataset:

dataset_excel.gif

 

Here is my report:

dataset.gifdataset

Here is  the slicer:

slicer.gifmy slicer

 

vincent2369 Regular Visitor
Regular Visitor

Re: How to GROUP BY parameters in Power BI Report Builder ?

@tejaswidmello I'm aware that I'm talking about Power BI Report Builder on the Power BI Desktop forum (since there is no Power BI Report Builder forum yet) and I'm also aware that it's still in beta version but I'm wondering if anyone had a solution to my problem!

tejaswidmello Established Member
Established Member

Re: How to GROUP BY parameters in Power BI Report Builder ?

Hi  @Vincent

I dont know why I am unable to recreate your issue.

May be I am missing something.

Please see my screesnhot below I dont see any dups in my slicer

Supplier 2

Capture 13.PNG

 

Supplier 1

Capture 12.PNG

Capture 11.PNG

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,155)