Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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"
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello Jayleny,
    any help with the data I was able to provide ?
    Thanks,
    Marketa