Showing results for 
Search instead for 
Did you mean: 
New Member

Multiple dynamic variables in report

I'm in need to created totally dynamic reports in PBI. I have researched and found several ways that allowed for some flexibility -- usually using DAX and an additional table construct. 


Maybe my request ist not for PoweBi, in which case I rather learn it know. I really like the power that PBI brings but are concerned that my use case might not be covered.


I have a web front-end that allows for the creation of mathematical models. Every model creates a result output that can vary in regard to names of the variables and the number e.g.

- salesTotal, RepsTotal, Baseline in output1,

- marketCap, numberReps, TotalDollar, CountryDollar in output2 .... 

There is a number of reports that essentially need to now take these output vars and visualize them. Except, how does one plug a variable into a report without knowing the name?


Any help or hint is highly appreciated.



Helpful resources

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.