Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all.
First time post, so please forgive me if the answer is obvious. I'm seeking to create a pareto chart with customer name on the x axis and volume on the y. This chart must be dynamic and adapt when I change the date fields and selected site.
I have this working perfectly when only one whole month is selected by first building a new table as follows:
MMByCustomer =
SUMMARIZECOLUMNS (
'Query1'[site_name],
'Query1'[customer_name],
'Query1'[full_date],
"Result",sum(Query1[actuals_material_margin_corp])
)
And then using the following measure:
Cumulative2 = SUMX (
FILTER (
ALLSELECTED (MMByCustomer),
'MMByCustomer'[Result] >= Max ( MMByCustomer[Result])
),
MMByCustomer[Result])
The result for one month is perfect:
Unfortunately, when I expand to two months, the cumulative total stops functioning as expected:
For the record, when I filter, I am using slicers linked to MMByCustomer[full_date] and MMByCustomer[site_name].
Many thanks in advance,
ConfusedWolf
@ConfusedWolf Try this approach: Better Running Total - Microsoft Fabric Community
Thanks for the advice Greg. Sadly, I still can't get that to work. On your example, you have the months on the x axis, but I am trying to see customer name on mine. I can't figure out how to adapt your approach to show this.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |