Forum Discussion

pstanek's avatar
pstanek
Post Patron
10 years ago

MAX MIN

I have table with columns   Office -Product-  Stock Value. I need to create  Product - MIN Stock - Office with min stock - Max stock - Office with max stock   I try to avoid to order new product...
Need Help
Show and Tell
pstanek's avatar
pstanek
Post Patron
10 years ago

Thanks, It works for some examples. 

 

  I have another idea, but I dont know , if it is possible.

 Can I sort table by levels? I have table within report. I would like to sort it by product, and second level by office. Is it possible?

 

I need to find solution, when stock table exists only within report, but it is not in query. I mean it has been created  through relations.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi pstanek,

Do you want to sort the table in Report view or Data view of Power BI Desktop? Could you please show sample data of your table and post the expected result?


Thanks,
Lydia Zhang

    • pstanek's avatar
      pstanek
      Post Patron
      10 years ago

      I am not really sure what the difference is . I mean difference between table in Report view or Data view of Power BI Desktop.

       

      Result of using matrix is sufficient for now.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        The data view is just the raw tables in your data model. The report view is for building the visuals that the end users will see and interact with. A matrix is one of those visuals, just as a bar chart is.