help on histogram click to display other field

[jip34]

hi

I have done an histogram with 5 calculated measure like this : 

Battery health < 20% = 
    COUNTROWS(
        FILTER(
            battery_all, 
            battery_all[BatteryHealthValue] <= 0.2
        )
    )

it represent x axis

on y axix it's the number of devices (Name field in my table)

but i dont use this field in my histogram

i want if it is possible to display the list of devices in a table view when I click on one of the histogram bar?

thanks 

[rajendraongole1 · Accepted solution]

Hi @jip34 -  Your measure calculates the count of rows in the battery_all table where the BatteryHealthValue is less than or equal to 0.2. This is a good starting point for your histogram.If your histogram categories are dynamic, consider grouping them using measures

Battery health < 20% =
COUNTROWS(
FILTER(
battery_all,
battery_all[BatteryHealthValue] <= 0.2
)
)

Click on a histogram bar (e.g., Battery health < 20%).
Check the Table visual; it should display only devices (Name) falling within the selected category.