Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Pros,
I'm really new to Power BI (how manny times have you heard that :)) and am really loving the tool.
I have encountered an issue that I am unable to find a solution for - probably because I am asking it incorrectly (don't know all the tecjnical jargon). 🙂
I have built a 'project' with various visualization graphs to display my monthly stats. I am calling my data from CSV files and have just noticed that one of my values (Target) is actually a constant value and repeated in most of my source CSV files.
If I put that value in another global/parameter file, how can I call the value from the respective queries that I have built so far?
Any help would be greatly appreciated.
Solved! Go to Solution.
In Power Query, you can add this to a Parameter
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
If you write a query that returns a single value, you can right click > Convert to parameter
You can call the parameter in files by simply typing the name. Note it the name of the parameter has spaces, you'll need the syntax:
#"Parameter with Space"
If you start typing though, intellesense should pick it up. I recommend reading the docs to familiarize with Parameters.
They can be used in Functions, or custom columns etc.
https://radacad.com/custom-functions-made-easy-in-power-bi-desktop
Appreciate your Kudos
Connect with me!
Stay up to date on
Read my blogs on
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
In Power Query, you can add this to a Parameter
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
If you write a query that returns a single value, you can right click > Convert to parameter
You can call the parameter in files by simply typing the name. Note it the name of the parameter has spaces, you'll need the syntax:
#"Parameter with Space"
If you start typing though, intellesense should pick it up. I recommend reading the docs to familiarize with Parameters.
They can be used in Functions, or custom columns etc.
https://radacad.com/custom-functions-made-easy-in-power-bi-desktop
Appreciate your Kudos
Connect with me!
Stay up to date on
Read my blogs on
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Thanks so much Steve.
By adding a new column and 'linking' it to my parameter as explained in https://radacad.com/custom-functions-made-easy-in-power-bi-desktop I was able to resolve my issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |