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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors