Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help Needed - Sort Multiple Table based on value in table A

Hi Everyone,   I am working on Power BI Dashboard for Financial Data Table A: This year budget Project Name               Category A     Category B     Category C   Total Marketing X            ...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , If this a matrix column, it can only sort on sort column

 

Assume the data is like

Product Name, Category , Value

 

Then you can create a new column

 

Cat value= Sumx(filer(Table, [Category] = earlier([Category])) ,[Value])

Category 1 = [Category]

And mark cat value as sort column for Category 1, and use that in visual

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c