Forum Discussion
Helper IBlank on Filter
Hi,
I don't have any empty cells on my data data set. Please see on below
but on my filter I see a blank cells filter option. Please take a look below:
How to solve it?
Thanks
The problem is that in your Table Company you have a Ticker (LBSL) that is not in your table Sector Wise Company Name. Add LSBL to this table and blank will disappear. Probably you need also to add a calendar table in order to avoid all that Many to Many relationship you have in your model
6 Replies
- serpiva64
Solution Sage
Hi,
I think the problem is in your model.
If your fact table contains Garments that are not in the dimension table that contains Garment you get a blank line.
You can see this in this example:
These are fact and dimension table
Now here is the model
As you can see when you are in the report a blank line is added
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
mamunxv8Thanks for your help.
Please take a look below to see the table model. Both of my tables have garment columns.
- serpiva64
Hi,
i think you need to first create your star schema (you can look at the following video
https://www.youtube.com/watch?v=PMSN7evZFFE) for each table.
Then you can unify dimensions yhat are in common (you can look at the following video https://www.youtube.com/watch?v=TnyRsO4NJPc by Guy in a cube
Handling MULTIPLE fact tables in Power BI)
- serpiva64
The problem is that in your Table Company you have a Ticker (LBSL) that is not in your table Sector Wise Company Name. Add LSBL to this table and blank will disappear. Probably you need also to add a calendar table in order to avoid all that Many to Many relationship you have in your model
- mamunxv8
Thanks