Forum Discussion
undefined
Hi,
I am new to Power BI, I need your help.
My issue is this i want to create Ad hoc report in Power BI. Ad hoc report means i have a list of Dimensions and Measures and i want output like When i select A dimension and Measure it will show in the table.
Like this screenshot attached, Here i was selected theCountry and the NETSALES, so it is showing in a table, If I select anyother dimension or KPI it will also show in table.
Please help.
Thanks in Advance
3 Replies
Anonymous , Measure one you can use measure slicer. But for dimension, it is a bit tricky. Either you have to create bookmarks or convert columns to rows.
measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYMEbookmark : https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Dynamically change chart axis/row/groupby in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/Anonymous check this blog post to achieve the functionality.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
