Forum Discussion
Report With Specific Filters
I have determined how to do what I was looking for. The paramter configuration provides the ability to provide dynamic paramters that can be used in the query operation. In the Advanced Editor for a query you can integrate dynamic properties.
Hi petersi,
This can be way in a several different ways, you can have a hierarchy in your table, you can do a measure to make counts, you can make new columns. Did you already tried to play around with PBI and you data to simulate what you need? Can you give a little more detail what you want to achieve with your example?
Regards.
MFelix
I need someone who is familiar with data base concepts. I'm not going to modify anything in my TABLE. It has everything needed. I just need to know how a dynamic grouping can be done on the associated sataset in Power BI. My exampe I gave clearly indicates what I'm trying to do. Please refer to it and understand what it means to group data.
Hi petersi,
Just trying to help and when I ask for additional information is to give you the correct response to your problem I'm familiared with data base concepts, and when you use the group in a data base you use normally an aggregator of some kind (sum, count, distinct count, whatever) and the other columns you will return the dataset, sometimes when you do this without the correct aggregator you will get duplicated result in some columns (this is my experience with grouping in datasets).
As I said you can do the grouping in PBI in different ways, you can do it in measures, in new columns, in new tables, even in the advance query editor if needed, In your example you make an aggregation but then the result is a, b,c,d,e,f so sorry for not understading what you want to achieve, maybe someone else can help.
Apoligize for making you loose your time.
regards,
MFelix
Then how do you do it in Power BI where a filter can be placed so that the grouping is initiated in a specific way.
I.E. -- is there a way to configure a filter with three options
day
month
year
-- and when the user selects on option in the filter it generates a dataset with a grouping on the filter selection -- i.e. when the user selects month the dataset is generated based on a grouping of the assicuated date field on a month basis.
I know that grouping is used a lot with aggregation. I don't need to focus on that as I know what I want with the dataset after grouping is applied. My main question is how do you do GYNAMIC grouping. I.E. a dataset that is not generated with a fixed grouping but one that is generated with a selected grouping.
I have determined how to do what I was looking for. The paramter configuration provides the ability to provide dynamic paramters that can be used in the query operation. In the Advanced Editor for a query you can integrate dynamic properties.