Need your help on matrix visualization.
I would like to show percentage of each store as below
The formula percentage for each product should be = (product qty / total)*100
I want it to show like table on the right as the result
Anyone can help me ?
Solved! Go to Solution.
It;s ok guys
i got it
but may i know how to do percentage formatting?
Means, how can I ensure the percentage only show rounded percentage (without any decimal place)
0.54% should display as 1%
14.87% should display as 15%
Maybe create a DAX calcuated measure that you drag to your matrix which you have full control over the formatting for.
Here is a sample pattern for what the measure might look like:
Store A Percent = VAR RowTotal = SUM([Store A]) VAR GrandTotal = CALCULATE(SUM(Table2[Store A]),ALLEXCEPT('Table2',Table2[Store A])) RETURN DIVIDE(RowTotal,GrandTotal,0)
You can then format the measure using the formatting options on the toolbar as per this picture.
I would suggest you unpivot your table so that the stores are not in columns in their own right and look more like the picture below .
Hi again @aanmi
If you do unpivot, your DAX measure might look like this
Store Percent = VAR RowTotal = SUM([Value]) VAR GrandTotal = CALCULATE(SUM(Table2[Value]),ALLEXCEPT('Table2',Table2[Attribute])) RETURN DIVIDE(RowTotal,GrandTotal,0)
My measure formula look like this:
% = var bigTotal = SUMX(all(STOCK_Stationary[Product]),calculate (sum(STOCK_Stationary[Store]))) return divide (sum(STOCK_Stationary[Story])*100,bigTotal, 0)
but unfortunately the percentage still have decimal points