Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ricardo2
New Member

How to create a parameter in a report connected through Livequery to SSAS

Hello,

 

i would like to know, if a develop a report (in PBI Desktop) connected by livequery to an SSAS model, how can i create a parameter so that i can create for example a dropdown by year - preferently without having to do anything from the SSAS model side.

 

Regards

 

2 REPLIES 2
Anonymous
Not applicable

hello you can use the "Enter data" or a distinct in you query...

enter data.PNG

 

after this you can find the field whit a measure like:

"

IF(HASONEVALUE(Periods[Mercado]),SWITCH(VALUES(Periods[Mercado]),
"Autoservicios....", [Value Area MTD],
"cash & C....", [Value Area YTD],
"Mayoreo P...", [Value Area RY])) etc

"

Anonymous
Not applicable

Hello @Anonymous 

 

Thank you, but i think your tip doesn't work for what i need; if you are connected through LiveQuery, you don't have access to PowerQuery and to that button in particular.

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.