Forum Discussion

JEC0210's avatar
JEC0210
Frequent Visitor
2 years ago

Filtering on PowerBI Totals

Hi all,     I have a column as part of a table visualisation, I want to filter the rows in the table such that the Total manual orders will only show the rows that sum to the "conversion...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JEC0210 ,

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Clara Gong

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

JEC0210's avatar
JEC0210
Frequent Visitor
2 years ago

Hi Clara, below is some sample output, I want to limit the table visual so that the manual orders should total to 4 (the orders to convert), that is, it should only show company b and company a. 

I do have this as a sample pbix file as well, but was unable to attach it, getting error file type .pbix is not supported, do you know how I could share it?

 

Cheers,

JEC0210

  • JEC0210's avatar
    JEC0210
    Frequent Visitor
    2 years ago

    Here is some extra context behind what are measures and what are tables:

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JEC0210 ,

     

    You can try logging the account out in power bi desktop and uploading it again.

     

    You can also change the sensitivity of the file to public.

     

    Best Regards,

    Clara Gong

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

    • JEC0210's avatar
      JEC0210
      Frequent Visitor
      2 years ago

      Hi Clara,

       

      I have tried logging out and uploading, still has the same .pbix is not supported error message. With the sensitivity method, the sensitivity drop down is locked and I am unable to adjust it to public. Do you know of any other way to attach it?

       

      Cheers,

      JEC0210