Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The above matrix is how the original one looks like. I would like to display only quantity sold columns and total current inventory column but hide all current inventory columns by date. I would like to display only total current inventory.
Below matrix is how i want it to be looked like.
I tried using *word wrap* from *column headers* to hide all current inventory columns except the total one. However, if i export data, it will show all current inventory columns by date. Furthermore, if i expand all down one level in the hierarchy to month from quarter, i have to manually hide curren inventory columns... ALSO, the below matrix size looks ugly compared to upper one.
Hi @Anonymous ,
Sorry for that if you put the Qty sold and inventory in Values, Matrix table cannot show the Total only, it will show the value in each column.
Maybe you can use the one matrix table cover another matrix table.
If you have any question, please kindly ask here and we will try to resolve it.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
You can create measure like this.
_Amount = IF(HASONEVALUE('Date'[Quarter]),SUM(Qty[Qty]),SUM(Qty[Amount]))
This will return Qty when you put it in Quarter otherwise it will show Amount if more than 1 quarters are selected....
you can replace it with your columns to check the results.
Proud to be a Super User!
Hi @Anonymous
Hiding a column is not an option.
You can create a measure to sum up the total and display.
Total_Sku_year = CALCULATE(sum(table[quantity_sold],Allexcept(table,table[sku],table[Year_from_date]))
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous , I doubt there is an option to hide a column from the total. But you can make it blank using is filtered.
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |