Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Create True/False filter

Hi All   i wish to create a true/false filter on a report. we log case numbers of our support cases into our VSTS system to track developmental items against a raised issue   in my powerbi repor...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi Anonymous,

 

There's a Group By option in Power Query. Go to Edit queries -> Transform -> Group By. Did you mean this?

 

I'm not quite clear about what you want. Could you please share us more detailed information like some sample data and your expected reuslt if possible?

 

Thanks,
Xi Jin.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    v-xjiin-msft wrote:

    Hi Anonymous,

     

    There's a Group By option in Power Query. Go to Edit queries -> Transform -> Group By. Did you mean this?

     

    I'm not quite clear about what you want. Could you please share us more detailed information like some sample data and your expected reuslt if possible?

     

    Thanks,
    Xi Jin.

     

    no that is not what i am after as i cannot group how i want

     

    essentially i want to group by if the cell/column field is blank or the cell is filled out with data.

    why? as i have a field with 1000 different case numbers. so i wish to group if the case number is blank or case number has info

     

    i can do this via creation of another column and using a formula, but wondering if there is any other inbuilt solution/function i am not aware of

    • Floriankx's avatar
      Floriankx
      Solution Sage
      8 years ago

      Honestly, I think creating a calculated column is the best way if you want to add it to your PivotTable row area.

      So you can give the group for case number or no case number any name you wish.