Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All.
I have a model that gets it data from a Power BI model in the same App Workspace. Let's call one the 'REPORT MODEL' and one the 'DATA MODEL'.
On the REPORT MODEL, there is a Report Level filter to remove one field's BLANK value.
or:
I create a single Dashboard from some charts from this model.
When I enter a phrase in Q&A, the resulting chart OBVIOUSLY includes those (Blank) values. BUT, when I open the Visualizations and Filters pane to apply a filter to the chart that Q&A rendered, and try to apply the same filter here (removing Blanks), I don't see "(Blank)" as an option to exclude.
If Q&A is going to go back to the DATASET (the DATA model) to get it's data, then I should have the ability to filter out the Blanks.
I can switch to ADVANCED FILTERING for this field and find the option that says, "is not blank", and that works, but in my opinion, if there is data that shows up with "(Blank)", then there needs to be that option in the Filters.
I see this as a BUG
COMMENT: NO, I cannot filter Blanks in the Power Query of the DATA model as this model will be used for other REPORT models that will need that data included.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.