Forum Discussion

buchta's avatar
buchta
Frequent Visitor
1 year ago

group lines when all selected

Hi    I would like to create a measrue that will show the average price in specific way in line chart.  I have DIM Container table with ISO Code and I have Fact Table with Price per day and Isocod...
Need Help
buchta's avatar
buchta
Frequent Visitor
1 year ago

hey OwenAuger thanx for quick respond.. the solution looks great but I think its not possible with Direct Query... because of the creation of field parameter which is not supported for DQ

 

OwenAuger's avatar
OwenAuger
Super User
1 year ago

Hi again buchta 

Even if you have tables with partitions with DirectQuery storage mode, you should still be able to create field parameters (which are calculated tables with Import storage mode). Also if you're using composite models on Power BI or Analysis Services then you should definitely be able to create/use field parameters (in the local model).

 

I just tested this myself with a simple model with DirectQuery connection to SQL Server and added a field parameter.

 

Could you clarify which sources you are connecting to with DirectQuery and confirm whether Modeling > New Parameter > Fields is available when the model is open in Power BI Desktop?

 

Regards,

Owen