cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Remove row with null cells in visual

Hello everyone!

I have a matrix visual (shown below) that I have some measures applied to it. There are some empty/null cells that exist though. Is there a way to remove a row with an empty cell in the visual? Thank you!

Annotation 2020-06-22 111329.png

 

Here are the measures used:

Before Dialog Steps = 
    var __BeforeDialogSteps = 
        SELECTCOLUMNS(
            FILTER(
                ST03N;
                [Date Time] = [Before Date]
            );
            "__BeforeDIA"; [Number of Dialog Steps]
        )
return
    __BeforeDialogSteps
After Dialog Steps = 
    var __AfterDialogSteps = 
        SELECTCOLUMNS(
            FILTER(
                ST03N;
                [Date Time] = [After Date]
            );
            "__AfterDIA"; [Number of Dialog Steps]
        )
return
    __AfterDialogSteps
Percentage Difference Between Checkpoints = 
    var __Difference = [After Dialog Steps] - [Before Dialog Steps]
return
    DIVIDE(__Difference; [Before Dialog Steps])

 

1 ACCEPTED SOLUTION

Hi @Anonymous ,

You can filter out the data with null by Filters panel:

filter pane.JPG

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@Anonymous , with screenshot not clear which row you want to delete



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Anonymous
Not applicable

Hi @amitchandak 

Sorry I thought it was clear from the description. If a cell is empty in any column I would like to delete that row. So wherever you see an empty cell I want that row deleted! I hope that makes more sense.

Hi @Anonymous ,

You can filter out the data with null by Filters panel:

filter pane.JPG

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Hi @yingyinr!
Thank you for your reply! Yes I found it after a bit more research on the filters. I thought it was much more complicated than that so my mind was fixed on creating a measure 😛

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.