Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Goodmorning,
I'm working on a report to show the occupation of certain machines in days. I have a Start Date and End Date linked to a calender, and got the count of days in the slicer working correctly. But i'd like to show the data in percentages.
I want to filter in years, months and weeks. So for instance in week 42 of 2018 when a machine is occupied for 7 days the occupancy should be 100%. If it is possible i want the data at the bottom of the bar to show the occupancy in a percentage.
And when i change the filter to a month, it should calculate the occupancy in days/month.
Thanks in advance for any help!
Solved! Go to Solution.
Please provide sample data table to be able to understand correctly.
Instead of using the data directly from the table, you can create a measure that follows your filter selection.
Something like
SelectionMeasure =
if(isfiltered(monthSlicerTable),
divide(distinctcount(datatable[days],
day(
date(
selectedvalue(yearSlicerTable[year]),
selectedvalue(monthSlicerTable[month])+1,
1
)-1),
0),
divide(distinctcount(datatable[days], 7, 0)
)
Then you can use the measure in your visual
Please provide sample data table to be able to understand correctly.
Instead of using the data directly from the table, you can create a measure that follows your filter selection.
Something like
SelectionMeasure =
if(isfiltered(monthSlicerTable),
divide(distinctcount(datatable[days],
day(
date(
selectedvalue(yearSlicerTable[year]),
selectedvalue(monthSlicerTable[month])+1,
1
)-1),
0),
divide(distinctcount(datatable[days], 7, 0)
)
Then you can use the measure in your visual
The table at the top right is the data i'm working with. I editted out some "secret" info.
As i filter the count of date changes to the amount of dates it is occupied in that given periode.
Will look into your dax formula to see if i can work it out.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
117 | |
84 | |
49 | |
38 | |
28 |
User | Count |
---|---|
188 | |
76 | |
73 | |
54 | |
42 |