March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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.
And i wish to have this result. It's the difference between each date... I try several DAX without success..
Capacity overview description | Capacity period of date | Percentage utilization | Date extraction |
[1900] 30420-01 (001) | 22/04/2024 | 0 | 15/04/2024 |
[1900] 30420-01 (001) | 22/04/2024 | 47 | 22/04/2024 |
[1900] 30420-01 (001) | 22/04/2024 | 72 | 23/04/2024 |
Solved! Go to Solution.
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:
Visualizations > Format > Bars > Select the measure and change its Transparency to 50%.
Same to another bar.
Then select All, open the Overlap and change the Space between series to 100%.
Open the Data labels.
The result is as follow:
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.
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.
Then add a Clustered bar chart like this:
Visualizations > Format > Small mutiples > Change the Columns to 1
The result is as follow:
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 @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.
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.
Then add a Clustered bar chart like this:
Visualizations > Format > Small mutiples > Change the Columns to 1
The result is as follow:
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
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:
Visualizations > Format > Bars > Select the measure and change its Transparency to 50%.
Same to another bar.
Then select All, open the Overlap and change the Space between series to 100%.
Open the Data labels.
The result is as follow:
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.
User | Count |
---|---|
122 | |
99 | |
89 | |
73 | |
65 |
User | Count |
---|---|
138 | |
115 | |
115 | |
98 | |
98 |