Slicer for text

[Heinrich]

Hello
I have a table that has following Data

Column A = Company

Column B = Old Version or New Version

Column B is Text

This table is displayed in Power BI Desktop

I would like to do a slicer which gives me the range. 

i.e. which company has more than 500 installed versions of Old Version 

or 

i.e. which company has more than 500 installed versions ob both versions.

Thank you

Heinrich

[Anonymous]

Hi @Heinrich ,

I made simple samples and you can check the results below:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Heinrich]

Hi  v-tianyich-msft
Thank you very much.

I had a missunderstanding.
I would immagine that I would do another table as written below.
Calclulating old and new version for every company and adding a slicer to filter

So if there are 

Then the new table would be created like

From there I could add 2 slicers one for with old and new version

and if needed total

Regards

Heinrich

[Anonymous · Accepted solution]

Hi @Heinrich ，

Try the following table expression:

Table 2 = ADDCOLUMNS('Table',"Old Version",CALCULATE(COUNTAX('Table','Table'[UPN]),FILTER(ALLEXCEPT('Table','Table'[Company]),[Version]="Old")),
"New Version",CALCULATE(COUNTAX('Table','Table'[UPN]),FILTER(ALLEXCEPT('Table','Table'[Company]),[Version]="New")))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Heinrich]

Hello
Fantastic work.
Would it be possible to have a slicer of total "Old Version" + "New Version".
Regards
Heinrich

[Anonymous]

Hi @Heinrich ,

Since measure can't be put into slicer, maybe you can try to use calculated columns, which will work.

Best regards,
Community Support Team_ Scott Chang

[Heinrich]

Thank you everything worked great 🙂

[Heinrich]

Hello

I believe this can only work if I make a new table with the total of all users per company

than I can add this to the slicer.
Regards
Heinrich

[Heinrich]

Hello
Thank you.

I would like to have a slicer that gives me the total of all UPN's 

Therefore be able to select the range to show only companies that have 2 or more users
It would be great also to be able to select only new or only old version. But this can be done by having a second slicer.

I think I have to copy column A to a new table and count for every company old and new version 

and add it to the new table. So the table would look like

Column A = Company Name

Column B = Total New 

Column C = Total Old

How could I do that best?

Regards
Heinrich

[Uzi2019]

Hi @Heinrich 
Can you share sample input data and expected output/ screenshot for better understanding.. 

Thanks,