Matrix component - order question

[Bartek_Smith]

Hi, 

PowerBi is sitll a new tool for me... my comapny is changing from Tableau to PowerBi. Trying to migrate some Tableau's report to PowerBi I stucked in with matrix component. I need to create a table where each value is deviced per months, like "Zuzycie_tot" and below this name are presented values in selected months, then next value "Koszt_tot" with all coresponding month...but I cannot set this order in PowerBI. Is it possible to do this in PowerBI?  If yes, how to do this modyfication?

I have attached the scrrnshots from tableau and powerBI.

Tableu:

PowerBI:

[FBergamaschi]

Hi @Bartek_Smith 

you can obtain this result in Power BI where you see for each month both calculations in values, see the settings of the matrix on the right in red squares

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Bartek_Smith]

Hi I think this not solve the case. Still 2 measures are ordered by month, not 1 measure and values per months

i.e in Tableau

[danextian]

Hi @Bartek_Smith 

Currenly, measures are always at the lowest level of the hierahcy. The workaround is materialize the measures in a disconnnected table and reference that table in a conditional measure to return the desired value.

Please see the attached sample pbix.

[Ladislauandre]

Hi @danextian.

This is a good soluction, but it will also increase model size.

Is there a better solution? using visual calculations maybe.

[Bartek_Smith]

Is this solution efficeint? If I good understand I need to do a copy of my orginal table measures.
My source has aroud 800k records sa i double them