Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to make this graph order wise like below
Solved! Go to Solution.
Hi @THENNA_41 ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a sorted table by manual typing. You can also put this sorted table on a cloud-based file (e.g. OneDrive), which makes it easy to maintain and refresh later.
2. Select the field "Reduction buckets" and sort by column "Order"
3. Update the formula of your measure [Total Month] as below:
Total Month =
VAR _selbucket =
SELECTEDVALUE ( 'OrderTable'[Reduction buckets] )
RETURN
IF (
_selbucket = "Total Month Variation",
CALCULATE (
SUM ( 'Master Data Base'[Value] ),
ALLSELECTED ( 'OrderTable'[Reduction buckets] )
),
CALCULATE (
SUM ( 'Master Data Base'[Value] ),
FILTER (
'Master Data Base',
'Master Data Base'[Reduction buckets] = _selbucket
)
)
)
4. Create a clustered column chart(Axis:Reduction buckets of table OrderTable Values: Total Month)
Best Regards
Hi @THENNA_41 ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Create a sorted table by manual typing. You can also put this sorted table on a cloud-based file (e.g. OneDrive), which makes it easy to maintain and refresh later.
2. Select the field "Reduction buckets" and sort by column "Order"
3. Update the formula of your measure [Total Month] as below:
Total Month =
VAR _selbucket =
SELECTEDVALUE ( 'OrderTable'[Reduction buckets] )
RETURN
IF (
_selbucket = "Total Month Variation",
CALCULATE (
SUM ( 'Master Data Base'[Value] ),
ALLSELECTED ( 'OrderTable'[Reduction buckets] )
),
CALCULATE (
SUM ( 'Master Data Base'[Value] ),
FILTER (
'Master Data Base',
'Master Data Base'[Reduction buckets] = _selbucket
)
)
)
4. Create a clustered column chart(Axis:Reduction buckets of table OrderTable Values: Total Month)
Best Regards
I want to make this graph order wise like below
User | Count |
---|---|
14 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
14 | |
4 | |
3 | |
3 | |
2 |