Checking/Filtering data in the Edit Dataset Pane

Q&A
, ,
1

Hi All, good Morning

I want to check the data at the edit pane level by filtering like in power bi. Is it possible? or is it limitation?

image
image1512×595 41.5 KB

image
image1092×730 35.6 KB

2

Hi @Venkat.Metadata,

This is not possible at the moment, the idea is that you will perform the filtering and design operations in the Analysis view. Having filters created in the dataset will make the dataset less “generic” to be used in different dashboards. If you want to filter the dataset because it is too big for use, you can use custom SQL if it is a fixed filter or you can also use dataset parameters to filter the dataset in real time based on a parameter on your analysis.

Hope this helps.

3

Thanks for the info. I think QS is not suitable what i need as of now.

4

Hi @Venkat.Metadata,

Just to clarify, we do have filtering at dataset level.

image
image378×523 18.8 KB

And you can also add calculated and predictive fields at this level.

image
image489×241 15 KB

We might not have the exact functionality that you show in PowerBI.

Hope this helps!

5

Thanks for the Info.