Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |