Forum Discussion
Matrix component - order question
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:
Hi Bartek_Smith,
Please provide PBIX that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data?https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI…
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/144…Thank you.
8 Replies
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.
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 themHi danextian.
This is a good soluction, but it will also increase model size.
Is there a better solution? using visual calculations maybe.
It wil increase the model size but the change should be negligible. You are not creating another table containing the results of your measures but simply a table that holds the measure names. If there are two measures, you will be creating a table of two rows only.
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
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
Hi Bartek_Smith,
Please provide PBIX that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data?https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI…
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/144…Thank you.
Hi Bartek_Smith,
I'm checking in to see if your issue has been resolved. If not, please share the PBIX file and let us know if you still need assistance.
Thank you.
Thank you.
