Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
2 years ago
Solved

Slicer for text

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

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

9 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

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

     

    Thanks,

  • Heinrich's avatar
    Heinrich
    Post Partisan
    2 years ago

    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

  • Heinrich's avatar
    Heinrich
    Post Partisan
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Heinrich
      Post Partisan
      2 years ago

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        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.