topic Re: How to plot pie chart correctly without creating additional column in DAX Commands and Tips

How to plot pie chart correctly without creating additional column

Bidu — Sat, 16 Sep 2023 10:07:29 GMT

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).

Re: How to plot pie chart correctly without creating additional column

tamerj1 — Sat, 16 Sep 2023 11:36:06 GMT

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

)

Re: How to plot pie chart correctly without creating additional column

Bidu — Sat, 16 Sep 2023 18:22:05 GMT

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

Re: How to plot pie chart correctly without creating additional column

tamerj1 — Sat, 16 Sep 2023 18:26:38 GMT

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.

Re: How to plot pie chart correctly without creating additional column

Bidu — Sat, 16 Sep 2023 18:56:14 GMT

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

Re: How to plot pie chart correctly without creating additional column

tamerj1 — Sat, 16 Sep 2023 19:22:59 GMT

Bidu

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

Re: How to plot pie chart correctly without creating additional column

Bidu — Sat, 16 Sep 2023 20:19:33 GMT

Thank you for attention