What kind of visual suitable.

[gopichilla]

Hi All,

My dashboard is connected to a web page.

I want here suppose one user location is India, This condition only showing India related data only not for all locations.

Here what kind of visual is suitable can anyone give suggestions, It is my project backbone.

Thanks,

[vanessafvg]

@gopichilla  i think you need to give a bit more information.  What sort of data are you showing?  what is the time period for the data.  Are you trying to show trend, sales, relationships?

this is a great reference for visuals

http://www.sqlbi.com/wp-content/uploads/videotrainings/dashboarddesign/visuals-reference-may2017-A3....

[gopichilla]

Thanks for quick response. 

I have coaching centers in different locations like in India(Hyderabad, Mumbai, Dhile....).

Here I try to show, user present in Mumbai only visible coaching centers in Mumbai not for all.   

[v-chuncz-msft]

@gopichilla,

According to your description, you may take a good look at Row-level security (RLS) with Power BI.

[gopichilla]

How can I apply row level filter I have 1500+ records in my database and in the feature will add some records.

[GilbertQ]

Hi @gopichilla

Do you perhaps just want to filter your data so when you select a location it ONLY shows you the related data?

If that is the case you can use the visual called "Slicer" and then put in your Location into the Slicer Field. Then when you click on a value in your slicer, it will filter to ONLY show you the related data for your location.

Here is a tutorial explaining: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/

[gopichilla]

Thank you for your answer, but I have 1500 records in my database. 

How can I apply filter/slicer?

It is my opinion can I use Geo-graph with fields like Location,  Latitude, Longitude,   value field it is possible or not.