Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create a descriptive satistics table?

Hi everyone! I have a table with some fields - deliveries, sales, forecast and returns - for which I would like to create a table visual showing 3 very basic descriptive statistics: minimum, maximum...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    Based on the sample data you provided, I created a test pbix file

    Select the two columns and click unpivot other column.

    Then create the measure according to your requirements and drag them into the matrix.

     

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

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Try to Unpivot the table in query editor.

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    V-lianl-msft ,

     

    Which table exactly do you suggest I unpivot? This is the table on which the measures are calculated:

     

    The table visual does not have fixed values, since they change based on slicers on the page. 

     

    This is how the table visual looks as of now, which is not what I intend:

    The image I posted in the original post is not from Power BI, but instead from a dashboard built with R shiny.