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...
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=vlnx7QUVYME
bookmark : 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/