Forum Discussion
Creating Bell Graph responsive to slicers for Total Learning Hours per Employee
Hello all, one of the "must have" requested by my report consumers is to create a Bell Chart that will show Distribution of total learning hours by unique employees (ID) that would be responsive ...
Hi Marketa01
Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
Hi Jayleny,
unfortuantely, I am not able to attach .pbix file here, the option is not enabled for me.
Sample data are below.
In addition I have created a calculated column in PBI (code below), but it is static calculation. I need it to be dynamic based on the filtering.
For example:
User Z004F80T for unfiltered data falls under category 60-70, but for filtered data Fiscal year 2024 (meaning October 2023-September 2024) he should fall under category 0-10.
The result should have outcome in this visualization:
CALCULATED COLUMN CODE:
CategoryAssigned =
VAR TotalHours = CALCULATE(
SUM('FACT_Report'[Duration hours]),
ALLEXCEPT(FACT_Report,FACT_Report[GID])
)
RETURN
SWITCH(
TRUE(),
TotalHours >= 0 && TotalHours < 10, "0-10",
TotalHours >= 10 && TotalHours < 20, "10-20",
TotalHours >= 20 && TotalHours < 30, "20-30",
TotalHours >= 30 && TotalHours < 40, "30-40",
TotalHours >= 40 && TotalHours < 50, "40-50",
TotalHours >= 50 && TotalHours < 60, "50-60",
TotalHours >= 60 && TotalHours < 70, "60-70",
TotalHours >= 70 && TotalHours < 80, "70-80",
TotalHours >= 80 && TotalHours < 90, "80-90",
TotalHours >= 90 && TotalHours < 100, "90-100",
TotalHours >= 100 && TotalHours < 110, "100-110",
TotalHours >= 110 && TotalHours < 120, "110-120",
TotalHours >= 120 && TotalHours < 130, "120-130",
TotalHours >= 130 && TotalHours < 140, "130-140",
TotalHours >= 140 && TotalHours < 150, "140-150",
TotalHours >= 150 && TotalHours < 160, "150-160",
TotalHours >= 160 && TotalHours < 170, "160-170",
TotalHours >= 170 && TotalHours < 180, "170-180",
TotalHours >= 180 && TotalHours < 190, "180-190",
TotalHours >= 190 && TotalHours < 200, "190-200",
TotalHours >= 200 && TotalHours < 210, "200-210",
TotalHours >= 210 && TotalHours < 220, "210-220",
TotalHours >= 220 && TotalHours < 230, "220-230",
TotalHours >= 230 && TotalHours < 240, "230-240",
TotalHours >= 240 && TotalHours < 250, "240-250",
TotalHours >= 250 && TotalHours < 260, "250-260",
TotalHours >= 260 && TotalHours < 270, "260-270",
TotalHours >= 270 && TotalHours < 280, "270-280",
TotalHours >= 280 && TotalHours < 290, "280-290",
TotalHours >= 290 && TotalHours < 300, "290-300",
TotalHours >= 300 && TotalHours < 310, "300-310",
TotalHours >= 310 && TotalHours < 320, "310-320",
TotalHours >= 320 && TotalHours < 330, "320-330",
TotalHours >= 330 && TotalHours < 340, "330-340",
TotalHours >= 340 && TotalHours < 350, "340-350",
TotalHours >= 350 && TotalHours < 360, "350-360",
TotalHours >= 360 && TotalHours < 370, "360-370",
TotalHours >= 370 && TotalHours < 380, "370-380",
TotalHours >= 380 && TotalHours < 390, "380-390",
TotalHours >= 390 && TotalHours < 400, "390-400",
TotalHours >= 400, "400+",
"N/A"
)