adhoc report in power

[sakshikaul]

HI 

I want to develop adhoc report in power BI.

Following is the format 

I want when usesr selects any dimension or any measure then the output should be seen in the table 

just like below image given

Is this possible in power Bi?

if yes ? the please provide the solution and If no then is there any alternative to create adhoc?

[Anand24]

Hi @sakshikaul ,

Couple of solutions that strike my mind:

1. Publish blank report and provide edit permissions to users. Provide them basic Power BI training to edit reports from services.

2. Create a report with Personalized Visuals feature of Power BI. Here's the link that will help you to understand concept of personalized visuals. You will also find videos in YouTube for the same.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[sakshikaul]

Hi,

Can you please send me some link to follow the steps for solution 1?

[sakshikaul]

sorry I want solution2?

[Anand24 · Accepted solution]

@sakshikaul ,

Refer below YT Videos for Solution2:

1. https://www.youtube.com/watch?v=eNP36ozsnss

2. https://www.youtube.com/watch?v=20HwiEhIShc

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Anand24]

@sakshikaul ,

Here's what you can do:

Step 1: Take the data source you want to use in your Power BI report

Step 2: Insert a text box at top with "Adhoc Report" written in it

Step 3: Place a slicer with year and configure it appropriately according to your single/multi select requirement

Step 4: Take a table visualization and keep it blank

Step 5: Save and Publish this report to Power BI Services

Step 6: Provide access to end user

Step 7: Provide end users Power BI Training on how to edit reports in services. This will give them the flexibility to click on blank Table viz you created and choose which fields to analyze

Step 8: Let end users know how to perform "Save As" from services

This is what it would like in services:

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[nvprasad]

Hi,

Yes It is possible, You need to use Matrix Visual. All row values from Dimention table should be appended one below one in a single column. So that based on selection of dimention row values changes.

Using Dax functions you can define required measure.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad