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

How to I make a "How to I make a "group by" on a slicer?group by" on a slicer

Hi Community,

 

I'm using Azure DevOps (ADO) for our developing, where we work Scrum like - and we have split up our Area Path like this:

 

Table: Area Path, rows:

  • IT\Building\NAS
  • IT\Building\NAS\NAS-TAM
  • IT\Building\CRM
  • IT\Building\CRM\CRM-TAM
  • IT\Building\O365
  • IT\Building\O365\KNOW
  • IT\Building\O365\Support
  • IT\Building\Misc\
  • IT\Building\Misc\Misc-COC
  • IT\Building\MAD\
  • IT\Building\MAD\Tam-support


I've used the ADO Analytics get create a report in PowerBI.

 

I want a overview of the Product Backlog Items in current sprint filtered by ie.

Area, using these area paths - handled by a slicer value called "O365 area":

 

  • IT\Building\O365
  • IT\Building\O365\KNOW
  • IT\Building\O365\Support

Or project, using these area paths - handled by a slicer value called "TAM:

 

  • IT\Building\NAS\NAS-TAM
  • IT\Building\CRM\CRM-TAM
  • IT\Building\MAD\Tam-support

Hope for you help :-)
Plz also post alternative setup to the slicer. I just need to filter som other graphs based on this.

 

If I'm in the wrong group plz push me in right direction.

 

Thanks :-)

 

/Michael

3 REPLIES 3
Moderator v-viig
Moderator

Re: How to I make a "How to I make a "group by" on a slicer?group by" on a slice

Are you developing a custom visual?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

vanghjort Frequent Visitor
Frequent Visitor

Re: How to I make a "How to I make a "group by" on a slicer?group by" on a slice

Hi Ignat,

 

No I'm not (yet)

 

/Michael

Moderator v-viig
Moderator

Re: How to I make a "How to I make a "group by" on a slicer?group by" on a slice

If it is not related to Custom Visuals we suggest to ask in Desktop

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com