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
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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

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.

Top Solution Authors
Top Kudoed Authors