Forum Discussion
Question about filtering
to show blank data i usually create an if isblank on my measure
for example
sales =
IF ( ISBLANK ( SUM ( table[values] ) ), 0, SUM ( table[values] ) )this usually forces a 0 value when empty and will bring back the data for everything, but i m not sure if thats the best way to do.
Well, I feel like an idiot now.
Thinking about relations, the problem was the way my data was organized.
What I did was make another Excel file with a table containing a column with the names of the clients (no duplicates), then I made a relationship in Power BI and use this clients table as my filter.
Now it shows the data the way I want.
Thank you for all the trouble, vanessafvg!
alvayag can you put some screen shots of the issue and also post a picture of your relationship view
Sure thing.
In the report view, that table show must have 28 clients (the clients associated with that vendor), but shows only the clients that actually bought something that month.
I want the full list.
I tried with the option "Show Items with no data" in the Values, but with no luck...
to show blank data i usually create an if isblank on my measure
for example
sales =
IF ( ISBLANK ( SUM ( table[values] ) ), 0, SUM ( table[values] ) )this usually forces a 0 value when empty and will bring back the data for everything, but i m not sure if thats the best way to do.
Well, I feel like an idiot now.
Thinking about relations, the problem was the way my data was organized.
What I did was make another Excel file with a table containing a column with the names of the clients (no duplicates), then I made a relationship in Power BI and use this clients table as my filter.
Now it shows the data the way I want.
Thank you for all the trouble, vanessafvg!