Forum Discussion
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).
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 measureIF (
SELECTEDVALUE ( CategoryFilter[Category] ) = "Yes",
COUNTROWS (
FILTER (
'Table',
'Table'[Value] = 0
)
),
COUNTROWS (
FILTER (
'Table',
'Table'[Value] > 0
)
)
)
6 Replies
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 measureIF (
SELECTEDVALUE ( CategoryFilter[Category] ) = "Yes",
COUNTROWS (
FILTER (
'Table',
'Table'[Value] = 0
)
),
COUNTROWS (
FILTER (
'Table',
'Table'[Value] > 0
)
)
)
For create the Table and insert the two rows, do I this on Power Query?
