Dynamic Clustered Column Chart

[Anonymous]

Hello,

I want to display a custom column chart based on the below data, with Region on the X-axis and a count of each row per region for both purchasers and requesters. Also I have a date slicer that filters the left column by month, and I'd like to counts to update according to that slicer. Any ideas for this?

[Anonymous]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create two measures.

PRUCHASE =
CALCULATE (
    COUNT ( 'Table'[Purchase region] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Purchase region] = SELECTEDVALUE ( 'Table'[Purchase region] )
    )
)

REQUESTER =
CALCULATE (
    COUNT ( 'Table'[Requester region] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Requester region] = SELECTEDVALUE ( 'Table'[Requester region] )
    )
)

If I have misundstood your meaning, please provide your desired output and pbix file without privacy information.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The chart you provided is not correct. For the same sample data in your pbix file the dark blue (Requester) line should only show 11 for CPN, yet it's showing 11 for all regions on your sample (the others should all be 0).

 Also I have a slicer on the page with the Submitted Date. Ideally I would like the clustered chart to update the count depending on the slicer. For example using the pbix file you provided if I were to change the slicer to only include dates for October 2021 the clustered chart should count a total of 3 for each measure, but it's still including the count for ALL dates.

[Anonymous]

Hi @Anonymous ,

If I have misundstood your meaning, please provide your desired output and pbix file without privacy information.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This is what the output should be when the Date Slicer Includes all dates

And below is what the output should be when the Date Slicer includes only Oct 2021

The system will not allow me to upload a pbix file, but the one you used will work. You just need to add a slicer and put the 'submitted date' field in the slicer.

[amitchandak]

@Anonymous , you can create a date slicer and filter. You  create a date without the time and join it with date table and use a filter/slicer from there

Date= datevalues([submitted date])

[Anonymous]

I've got the date slicer, what's difficult for me is arranging the X-axis. It keeps on showing the same amounts for both measures. For example, this is what it currently looks like

But I need it to look like this