Not being able to use measure in Shared axis

[Anonymous]

Hi,

I am new to PowerBI and will appreciate any help with my question.

My data set is similar to as shown below:

I have created this tablular visual from my dataset with columns Member_id and Interactions(calculated as distinctcount of Memberid, Date, Reason). Here, the 'Interactions' value will change with the slicers being applied.

Then, I added another calculated measure 'Buckets' as can be seen above which just bins the 'Interactions' values into 5 groups.

I want to have another visual like shown below:

How can I create this visual as I am not being able to drag 'Buckets' into the X-axis?

P.s : I am not defining a different table in the model because there the 'Interactions' column will not get affected by the application of the slicers.

Regards,

Diptanshu Lal

[amitchandak · Accepted solution]

@Anonymous , You need to do dynamic segmentation for that

You need an independent bucket table and measure using that

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[Anonymous]

Hi @amitchandak ,

Dynamic segmentation did help me solve the issue. Thank you for the quick reply. Your video on Youtube was very informative.

Regards,

Diptanshu Lal