Forum Discussion
Can we use the smart narrative functionality in a clickable format for drillthrough?
So I'm currently developing a mobile-view power BI report designed specifically to be looked at on devices.
What do I have working right now?
I have developed some prototype SQL script that takes some dummy data and basically puts it into a table with the following being an example record:
| Date | Newsfeed Item | Drillthrough ID (drillthrough page filter) | Criteria (destination page name) |
| 4-Nov-21 | Of Region Y Stores, Store X saw the greatest YoY increase of Product Z (+35%) | 124567 (e.g. maybe this is Store X, Region Y, Product Z) | Yearly Increase |
| 3-Nov-21 | Of Region Y Stores, Store A had the highest sales of Product B this week, at $45k sales | 654321 (e.g. maybe this is Store A, Region Y, Product B) | Weekly Sales |
What I can successfully do right now is have the user touch the newsfeed item (in the table), then click a 'details' button. This will take the page filters applied by clicking the newsfeed item, then go through to a tab called e.g. 'Yearly Increase' or 'Weekly Sales', with the drillthrough ID that will filter this page to the specific region, store, product etc.
The next step is to work smarter narratives into newsfeed (in the ideal world).
My question is: Can Power BI's smart-narratives be worked into a table or clickable chart of some kind that will allow me to do the above? E.g. I click the smart narrative, it gives me a 'drillthrough ID', and a 'Criteria' (destination page). By default, they are basically clever text-boxes, so we can't click-to-filter them.
If I cannot do this, then I might have to use python's ML capabilities to try and work smart-narratives into a table.
3 Replies
- v-luwang-msft
Community Support
Hi Micah_P ，
refer the following article ,and check if it is helpful .
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-smart-narrative
Best Regards
Lucien
- v-luwang-msft
Hi Micah_P ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien Apologies for the delay.
If I understand correctly, this article shows me how, by clicking and interacting with the charts on my dashboard, I can impact the smart narrative box.
I might not be reading properly, but what I cannot find is anything on doing the reverse - which would be clicking the smart narratives as if it were a table or a chart itself, to then drill-through to a page containing charts about this narrative. For example, I can currently use 'drillthrough' as an action on a button using a table (by clicking on the row). I assume it's just not the intended design of smart narratives, but I thought I might as well see what was possible 😂.
