Transform each category of line as table

[Ade1991]

Hi,

I have the following table, with three columns :

I would like to transform it to make each category of the first table as an independant entity (as a table ?).

My target is to be able to manipulate each of the categories independantly (currently, i'm using a filter in each of my visual, seems bad...).

Any advice about the best structuration is welcome.

Thanks

[VasTg]

@Ade1991 

You have to do it manually for each category if you would like to split.

Query Editor

https://community.powerbi.com/t5/Desktop/Splitting-a-table-into-two-based-on-column-value/td-p/11501...

DAX

https://community.powerbi.com/t5/Desktop/Split-Query-for-Tables/td-p/471686

I would still go with visual filter(or page filter if possible) if the categories are in double digits or more..

If it helps, mark it as a solution

Kudos are nice too

[Ade1991]

At the end, y target is to be able, for example, to compare two of type of line in the time. I have the date so it will be ok for my axis.

However, If I use filter, I won't be able to distinguish between them

I tried the first solution with Power Query, but I can't seriously to do it (I have so many lines).

[v-kelly-msft]

Hi @Ade1991 ,

You'd better create new tables by using dax expression such as below:

Table 3 = FILTER('Table','Table'[Date]=DATE(2016,8,1))

Then you will see:

 
Best Regards,
Kelly

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

[Ade1991]

Thanks for the answer

No way to make a loop for each unique value of the column ?

[AilleryO]

Hi,

Did you try to use CALCULATETABLE function ?

I use a measure like the one below to make a table with customer from the past 6 months :

TabClient 6 derniers mois = CALCULATETABLE(Clients;DATESINPERIOD(MonCalendrier[Date];TODAY();-6;MONTH))

Olivier 

[Ade1991]

Thanks 

However, in this kind of solution, I need to fill by hand each distinct name of lines.

No way to make a loop ?

[AilleryO]

Hi,

Oui en effet comme avec la solution en DAX...

Une autre piste pourrait être de créer une table de valeurs uniques avec Power Query :

= List.Distinct(Projet[Categorie])

Et ensuite de mettre en relations cette table de valeurs uniques avec votre autre table...

Peut-être cela peut déjà résoudre certaines problématiques...

Olivier