Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Maxime67
Regular Visitor

Cumulative difference betwen several extraction Data

Hello Guys, 

 

I have a specific extraction that show me how my production line are full. But i need to see how fast they are full by analysed day by day the new rate. 

 

For exemple witht the data, i want to see in a graph the split between the date extraction of my percentage utlisation. I can't use the legend in the vizualisation. 

 

So now i have this result : the last capacity update. 

 

Maxime67_0-1713881970364.png

 

And i wish to have this result. It's the difference between each date... I try several DAX without success.. 

 

Maxime67_1-1713882133669.png

 

Capacity overview descriptionCapacity period of datePercentage utilizationDate extraction
[1900] 30420-01 (001)22/04/2024015/04/2024
[1900] 30420-01 (001)22/04/20244722/04/2024
[1900] 30420-01 (001)22/04/20247223/04/2024
2 ACCEPTED SOLUTIONS
v-zhengdxu-msft
Community Support
Community Support

Hi @Maxime67 

 

Maybe you can try this:

First of all, I add a measure to get the max value of per [Capacity period of date]

MEASURE =
VAR _currentDate =
    SELECTEDVALUE ( 'Table'[Capacity period of date] )
RETURN
    MAXX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Capacity period of date] = _currentDate
        ),
        'Table'[Percentage utilization]
    )

 Then add a Clustered bar chart:

vzhengdxumsft_0-1713922570940.png

Visualizations > Format > Bars > Select the measure and change its Transparency to 50%.

Same to another bar.

vzhengdxumsft_1-1713922720604.pngvzhengdxumsft_3-1713922870761.png

Then select All, open the Overlap and change the Space between series to 100%.

vzhengdxumsft_4-1713922976823.png

Open the Data labels.

vzhengdxumsft_5-1713923118434.png

The result is as follow:

vzhengdxumsft_6-1713923138804.png

 

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @Maxime67 

 

The Clustered bar chart returnns aggregate values, maybe you can add a index column and open the small mutiples:
Transform data > Add Column > Index Column.

vzhengdxumsft_0-1713943221737.png

Then add a Clustered bar chart like this:

vzhengdxumsft_1-1713943296569.png

Visualizations > Format > Small mutiples > Change the Columns to 1

vzhengdxumsft_2-1713943534476.png

The result is as follow:

vzhengdxumsft_3-1713943713528.png

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Maxime67
Regular Visitor

Hello @v-zhengdxu-msft 

 

That's very intersting for a firs row. I never thought to use the bar chart in this way ! 

 

Really thanks. 

 

When i try to use your solution in a new file it's work, but in the current file, i don't have any measure which appears. Possible due to the data comes from several file ? I need to check. 

 

You respond at 50% of my issue. With your solution i have a view depending of the date of the extraction. But i the needs is to see that of the date "capacity period"n, like a resume of each step of the capacity by date. 

 

Maxime67_1-1713942360206.png

 

Really, thanks for your support

Maxime

Hi @Maxime67 

 

The Clustered bar chart returnns aggregate values, maybe you can add a index column and open the small mutiples:
Transform data > Add Column > Index Column.

vzhengdxumsft_0-1713943221737.png

Then add a Clustered bar chart like this:

vzhengdxumsft_1-1713943296569.png

Visualizations > Format > Small mutiples > Change the Columns to 1

vzhengdxumsft_2-1713943534476.png

The result is as follow:

vzhengdxumsft_3-1713943713528.png

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello

 

Sorry for the late answer. Again thanks for your input and help on this subject.

 

That not the result i'm looking for, still have the issue to have a lot of Data and i can check date by date. It will be perfect if i can see all the different input in the line of the 22 april like the original screen i provide. Maybe it's not possible to have this result. 

 

Thanks again and have a good week

v-zhengdxu-msft
Community Support
Community Support

Hi @Maxime67 

 

Maybe you can try this:

First of all, I add a measure to get the max value of per [Capacity period of date]

MEASURE =
VAR _currentDate =
    SELECTEDVALUE ( 'Table'[Capacity period of date] )
RETURN
    MAXX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Capacity period of date] = _currentDate
        ),
        'Table'[Percentage utilization]
    )

 Then add a Clustered bar chart:

vzhengdxumsft_0-1713922570940.png

Visualizations > Format > Bars > Select the measure and change its Transparency to 50%.

Same to another bar.

vzhengdxumsft_1-1713922720604.pngvzhengdxumsft_3-1713922870761.png

Then select All, open the Overlap and change the Space between series to 100%.

vzhengdxumsft_4-1713922976823.png

Open the Data labels.

vzhengdxumsft_5-1713923118434.png

The result is as follow:

vzhengdxumsft_6-1713923138804.png

 

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.