Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
Required assistance, I have created a column by using Divide function, result is showing in percentage.
Now i want to create another column/measure by using this, where i have segregate 0 to 20%, 21% to 50% & >51%, so that i can use this as slicer.
Regards,
Solved! Go to Solution.
Hi @harirao ,
You can create a column using the following DAX expression:
Refer: Binning and grouping
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
Hi @harirao ,
You can create a column using the following DAX expression:
Thanks, this solution worked.
Regards,
Hari
Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
Column1 | Column2 |
A | 1 |
B | 2.5 |
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |