The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |