Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I wish to implement the functionality like the screenshot below, such that when I select limit1 as 60 and limit2 as 120, so the bar graph will show like 1st bar should be '<60', 2nd bar should be between '60 to 120', 3rd bar should be 'more than 120'. And so on.
How can I implement this in Power BI? Is there any DAX measure that I need to implement?
Hi @Anonymous ,
If I understand you correctly, you want to dynamically display the X axis values based on slicer limit1 and limit2, and you want the Y axis values to change dynamically accordingly. It should be noted that the columns applied to the X-axis must actually exist, the measure cannot be applied to the X-axis. Is there such a value range column in your data model, or is there a value range dimension table in the corresponding data table? You can refer to the following link to implement it.
Create Buckets or Groups with Power Query in Power BI (Create group/range column base on some specific conditions)
Dynamic Segmentation of Customers – Power BI DAX
How To Create Dynamic & Custom Groupings For Your Data - Advanced DAX Technique
Otherwise, please provide some sample data with Text format(exclude sensitive data) and your expected result with the calculation logic and specific examples. Thank you.
Best Regards
@Anonymous , I doubt that.
Best you can do or bucket or binning
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
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |