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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gg_10
Frequent Visitor

Stored or Saved the result to database

Hi , I have a problem with the power bi . In my dashboard , I have a slicer as a slider . The slider will be drag by user , when the user drag the slider , the result will be stored or will be passed to database in server . How could i do that ?

7 REPLIES 7
AnkitBI
Solution Sage
Solution Sage

Hi - Currenlty, there is no default option to pass values from Report page to a Database. For Storage in a measure, see below.

 

Single_Selection = SELECTEDVALUE(Selection[Value])
Multiple_Selection = CONCATENATEX(filters(Selection[Value]),Selection[Value],",")

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

gg_10
Frequent Visitor

Hi, thank you for your helpSmiley Happy

Is there any other ways to store the output to the query table  ?

Not from the report.

gg_10
Frequent Visitor

If from dashboard ?

There is no option to pass through Report/Dashboard. In between - How are using Slicer in Dashboard. Have you pinned a live page?

gg_10
Frequent Visitor

Others than slicer what other tools i can use ? To store the result/output in query table.

Power Apps is one option. Rest options you can check in Developer Forum.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors