cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
villasenorbritt
Helper I
Helper I

SQL Views and BI

I am working with SQL to pull data into power bi. I made a view in SQL that has only what we consider "Good Data" and here is the table that represents that:

villasenorbritt_0-1653404198219.png

What I am stuck on is how to make a filter where they can see what we consider "not good" data. For example, if there was a piece of debris in the way of the sensor and it caused a miscalculation, I want them to be able to see that as well as it will determine if this is a continuous problem. How should I go about doing this? I'm a lot better with SQL so is it possible to create another view in SQL with the bad data and put that into a slicer? This community is the only place I can ever get accurate and helpful answers, so thank you in advance!

 

1 ACCEPTED SOLUTION
jcalheir
Resolver I
Resolver I

If i understood your question correctly, i will probably do the following:

 

Create a view with good and bad data, but add a column that (semething like "Data quality") that says if the current row is good data or bad data.

Then in Power BI you can filter your visuals using that field.

 

Hope it helps

View solution in original post

3 REPLIES 3
jcalheir
Resolver I
Resolver I

If i understood your question correctly, i will probably do the following:

 

Create a view with good and bad data, but add a column that (semething like "Data quality") that says if the current row is good data or bad data.

Then in Power BI you can filter your visuals using that field.

 

Hope it helps

Hey @jcalheir , I have another question that I think you might be able to help with. Lets say I am only wanting to show the "Good" data in my chart, but then I need the "Bad data" to be categorized into five different categories. How would you go about doing this?

@jcalheir See I knew someone on here would have a simpler, cleaner way to get this done. Thanks for your help!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors