Power BI Searchable Database

[JaClem]

Afternoon, I'm extremly new to PowerBI and I'm wanting to create a database our team can use to search up specific values/ I orginally attempted to make this in Excle but it was suggested that I try it here. Due to confidentiality I really can't say exactly what but as an example...

I created an excel sheet to help my team search up what color options were available for specific car brands. On the Y axis I listed the brands and on the X axis I listed the colors. To make things easier for myself I set it up where each cell had a drop down that would say either "Yes", "No", or 'N/A". WIth inventory always changing I figured this would be easiest so if we added a color it would only take me flipping one cell from "False" to "True" to update it. I'm trying to see if there's a way to search out of this table, particularly based off color, so we could search "Blue", for instance, and see every vehichle that currently has a blue color option. I honestly have no idea how I'd go about having a cell check a row and column at the same time to find the matching values and take a "Yes" or "No" from each cell to determine if that car brand should be listed. 

Any help is greatly appreciated. Thanks!

[v-lili6-msft]

hi, @JaClem 

For your case,  "To make things easier for myself I set it up where each cell had a drop down that would say either "Yes", "No", or 'N/A"." it couldn't be achieved in power bi. power bi is BI tool, It is used to analyze the data but not modify the data. to update data, you need to update it in data source and then refresh dataset in power bi.

And you may try to  this data model:

Dim table: Brands and Colors

Data table: it should be like this:

Brand

Color

othercolumn1

othercolumn2

…

Then create the relationship with Dim table: Brands and Colors

and then create the measure to count or sum the data table

Now drag dim fields from dim table as aslicer to fiter data.

There many power bi report example and documents for you to refer to:

https://docs.microsoft.com/en-us/power-bi/sample-datasets

Best Regards,

Lin