Forum Discussion
Need Help Urgent
I want to put filter on column , which has no value should not be in table atumatically .
7 Replies
mianjalil239 Sorry, what? Which column?
Which has no value
Hello mianjalil239,
Make filter is not blank.
Kind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |Hi mianjalil239 ,
According to the design of power bi, when you don't enter a value in the filter, it doesn't apply any filtering and the apply filter button is grayed out.
If you want this field to initially not show any data, you can set a condition that the filter is empty and later adjust it as needed.If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I want to put horizental filter if there is no value it should be not in table
I did this but it filter all column
Hi mianjalil239 ,
The Filters pane displays the fields in a single visual object as well as any other filters added by the report designer. So you can drag in fields that are not in the visual object to be filtered, the filters are filtering the data to be displayed based on all the results, so all values will be displayed if they are not filled in.
If you want to not show the data at first, you can try the parameter in the paginated report, if you don't set the default value, it will show the data after you select the parameter.
More details can be found in the documentation:
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn
Report parameters in Power BI Report Builder - Power BI | Microsoft Learn
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
