Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
27 | |
3 | |
3 | |
2 | |
2 |