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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors