topic Re: Pareto graph related to dates in DAX Commands and Tips

Pareto graph related to dates

Terrimaru — Tue, 25 Feb 2025 17:30:15 GMT

Hello,
I spent many hours with ChatGPT and unfortunately no results 😞
I have data:

Example

Date; Vendor Name; Value

Jan-2025; A; 50

Jan-2025; B; 40

Jan-2025; B; 80

Jan-2025; C; 30

Feb-2025; A; 30

Feb-2025; B; 50

Feb-2025; C; 80

Feb-2025; C; 30

etc.

I need pareto graphs, which will be related to chosen dates. For example, if I choose Jan-2025 it will shows: B = 120, A = 50, C = 30 (this step is easy, and this is done), and additional to it pareto line which will shows... pareto: B = 60% (120/200), A = 85% (170/200), C = 100% (200/200)

Once I change date to Feb-2025 it should calculate pareto based on new selected date.

I have tried with gemini and chatgpt, but gemini failed with error "Unexpected value for ORDER argument in ORDERBY function. Use 0/FALSE/DESC for descending order or 1/TRUE/ASC for ascending order." and nothing helped for it. And ChatGPT failed, as every solution it provides shows Vendor Name %, not cumulative value. It showed B = 60%, A = 25%, C = 15% instead of B = 60% (120/200), A = 85% (170/200), C = 100% (200/200)

Is anyone able to show me solution to this issue?

Re: Pareto graph related to dates

Irwan — Thu, 27 Feb 2025 00:29:11 GMT

hello Terrimaru

please check if this accomodate your need.

Hope this will help.

Thank you.

Re: Pareto graph related to dates

Terrimaru — Thu, 27 Feb 2025 07:22:00 GMT

Helo Irwan ,
Not really. It should looks like below. Pareto (graph) for choosen period (on the left).

Once I change period to next one (for example Feb-2025), Pareto graph should adapt as well to the new values

Re: Pareto graph related to dates

Irwan — Thu, 27 Feb 2025 23:25:59 GMT

hello Terrimaru

i see, please check if this accomodate your need.

i think the easiest way is creating new SUMMARIZE table (maybe other experts have better idea).

For the detail, please have a look at attached pbix.

Hope this will help.

Thank you.

Re: Pareto graph related to dates

Terrimaru — Mon, 03 Mar 2025 15:41:21 GMT

Hello,

Thank you for your support. I tried to adapt your solution to my report, but unfortunately there is an error (see attachment). I checked everything, and it seems my data are in the same format as yours. However still there is an error wchich do not allow me to make rank formula which seems essential here 😞

Re: Pareto graph related to dates

Terrimaru — Mon, 03 Mar 2025 16:33:07 GMT

small update. I was able to make function "rank" run, by adding it as a new column of "Summarize" (see screen, rank is there).
However now "Total" doesn't work. I add it to line y-axis, I make it percentage, I added "Rank" to Tooltips, etc., but the line do not want to appear ;/

Re: Pareto graph related to dates

Irwan — Mon, 03 Mar 2025 23:47:28 GMT

hello Terrimaru

please show how is your DAX for Total measure.

if you have a sample data from your original data, it would be helpful.

Thank you.

Re: Pareto graph related to dates

Terrimaru — Wed, 05 Mar 2025 08:58:58 GMT

Hello,

Please see below.

Also please see part of my data in excel. I can't find option here to attach excel itself 😞

Date: in months

Vendor Name: vendors - multiple lines with the same vendor

YS €: Value
Flow: flow

As I showed in the PowerBI graph above. I have stacked columns graphs, which shows "Vendor Name" on X-axis with sum of its value "YS €" on Y-Axis. Sum of vendor is sum of its flow (that is why there is stacked column, and you can see two colors).
What I miss in this graph is pareto which will be visible on graph as well and will be reacting to the chosen date (exactly as you showed in your previous comment).

Date	Vendor Name	YS €	Flow
lut.25	A	45316	factory warehouse
lut.25	A	6273	Supplier warehouse
lut.25	B	6303	factory warehouse
lut.25	B	8698	factory warehouse
lut.25	C	184	factory warehouse
lut.25	C	142	Supplier warehouse
mar.25	A	47 188	factory warehouse
mar.25	A	21	Supplier warehouse
mar.25	B	5 893	factory warehouse