Forum Discussion
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
- ankitpatiraCommunity 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.