Forum Discussion

keithpoplar's avatar
keithpoplar
Frequent Visitor
10 years ago
Solved

How do I aggregate over columns in Matrix

Hi all, I need some help here. Appreciate any advices.

 

I am implementing an existing Tabelau table using Power BI.

 

Here is how the existing table look like in Tabelau. 

The three columns pointed by red arrows are Min, Avg, and Max value of the time series data in the remainning columns (highlighted in red rectangle).

 

 

 

 

In Power BI, I tried Matrix visual by puting time series data into column and the result is shown below. But I can't get Min Avg and Max over the time series data shown in different columns.

Power BI Matrix

I also tried Power BI table, but in this case I can't get time series data shown in columns.

Basically, what I want is the combination of what shown in matrix and table.

Power BI Table

So what should I do? 

  • keithpoplar in power bi you can specify min, max or avg by clicking on a dropdown for the field as shown in below image. you can do that fields dropped on matrix visual.

     

1 Reply

  • ankitpatira's avatar
    ankitpatira
    Community Champion

    keithpoplar in power bi you can specify min, max or avg by clicking on a dropdown for the field as shown in below image. you can do that fields dropped on matrix visual.