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.
Hi all
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.
Hi @aanmi
Did you change the format settings of the measure to have 0 decimal points as per the arrows in the image I posted?
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)
E.g.
0.54% should display as 1%
14.87% should display as 15%
Hi @aanmi
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
Hi @aanmi
Did you change the format settings of the measure to have 0 decimal points as per the arrows in the image I posted?
thank you...i just know measure value can also be format use modelling function.
It works now
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |