Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I want to get a partition of my percentage values from the table .
for example i want to create a pie chart for the below % values like 10 to 30% , 30 to 50% & 50 to 80%
Based on this segments i will show the total counts under those segments covered in the pie chart.
Below the data from my table :
here 28% means it wil come under 10 -30% segment .
Like wise i want to split it .
Please help to sort this scene ..
Thanks
DK
Solved! Go to Solution.
Hi @dinesharivalaga ,
Please have a try.
Create a column.
Column =
IF (
( 'Table'[YTD CM%] ) > 0.1
&& ( 'Table'[YTD CM%] ) <= 0.3,
"10%-30%",
IF (
( 'Table'[YTD CM%] ) > 0.3
&& ( 'Table'[YTD CM%] ) <= 0.5,
"30%-50%",
IF (
( 'Table'[YTD CM%] ) > 0.5
&& ( 'Table'[YTD CM%] ) <= 0.8,
"50%-80%",
BLANK ()
)
)
)
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I have solved a similar problem in the attached PBI files.
Hi @dinesharivalaga ,
Please have a try.
Create a column.
Column =
IF (
( 'Table'[YTD CM%] ) > 0.1
&& ( 'Table'[YTD CM%] ) <= 0.3,
"10%-30%",
IF (
( 'Table'[YTD CM%] ) > 0.3
&& ( 'Table'[YTD CM%] ) <= 0.5,
"30%-50%",
IF (
( 'Table'[YTD CM%] ) > 0.5
&& ( 'Table'[YTD CM%] ) <= 0.8,
"50%-80%",
BLANK ()
)
)
)
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |