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
fpelloux
New Member

Sélectionner des colonnes et non des lignes

Bonjour a tous,

J'ai des données que je souhaiterais filtrer par colonne et non pas par ligne.

 

Exemple : 

Filtre 1 = Outils1

Filtre 2 = Price Level -> je renseigne "Price level B"

Et j'en ressors : 15

 

Colonne.jpg

Je n'ai pas du tout d'idées sur le "comment aborder la chose" sachant que PBI filtre des lignes.

 

Quelqu'un aurait-il une idée ?

 

Merci d'avance

Franck

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

Hi @fpelloux ,

 

Please unpivot table in Query Editor mode.

1.PNG2.PNG

 

In report view, add [Product] and [Price level] into slicers.

3.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @fpelloux ,

 

Please unpivot table in Query Editor mode.

1.PNG2.PNG

 

In report view, add [Product] and [Price level] into slicers.

3.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft 

Thanks you! It works very well!  Smiley Happy

Franck

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.