Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Bidu
Frequent Visitor

How to plot pie chart correctly without creating additional column

Hello everyone,

I have one column in my Table with integer values, I want report in a pie chart values > 0 and values == 0, and its percentage, but I dont want to create a additional column with values "YES":: >0 and "NOT":: == 0 for it. Is it possible? I'm newbie on dax (and I think to keep only essential information on Tables, maybe I'm wrong).

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Bidu 

you may create a disconnected single column, two rows table. Inset table manually, rename it like "CetegoryFilter, rename the column "Category" and inter "Yes", "No" in the first two rows. 
place CategoryFilter[Category] in the pie chart along with the following measure 

IF (

SELECTEDVALUE ( CategoryFilter[Category] ) = "Yes",

COUNTROWS (

FILTER ( 

'Table',

'Table'[Value] = 0

)

),

COUNTROWS (

FILTER ( 

'Table',

'Table'[Value] > 0

)

)

)

 

View solution in original post

6 REPLIES 6
Bidu
Frequent Visitor

For create the Table and insert the two rows, do I this on Power Query?

@Bidu 

From home menu in power bi click on "inset data". The table will be automatically created in power query 

Bidu
Frequent Visitor

Thank you for attention

Bidu
Frequent Visitor

@tamerj1 nice! Thanks.
Now I wanna know about your experience, which solution is more elegant to make this? Am I right about keep only essential information on Table. My intension is make a clear solution, without being a prolixic model

@Bidu 

Let's say your data is a couple of million rows. If you add a column then you're actually adding 2 million cells to your data model. The other solution requires adding 2 cells only. I don't think it is a hard question to answer. 

tamerj1
Super User
Super User

Hi @Bidu 

you may create a disconnected single column, two rows table. Inset table manually, rename it like "CetegoryFilter, rename the column "Category" and inter "Yes", "No" in the first two rows. 
place CategoryFilter[Category] in the pie chart along with the following measure 

IF (

SELECTEDVALUE ( CategoryFilter[Category] ) = "Yes",

COUNTROWS (

FILTER ( 

'Table',

'Table'[Value] = 0

)

),

COUNTROWS (

FILTER ( 

'Table',

'Table'[Value] > 0

)

)

)

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors