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.
I'm trying to create a dynamic dataset in Power BI. What i want to do is as far as i am aware not possible in Power BI:
I want to set a column in the query table to read in what the slicer has been selected for e.g. my formula in the query would be: 1000* slicer value. this column would then be used by subsequent columns to calculate an output.
However as said everything i know about Power BI says you cannot read dynamic data into the query.
So what i wanted to do was create a number of measures that create a new table dataset starting from that first point e.g. have a measure running from the slicer to do the initial calculation and then adding measures to that measure to complete the rest of my calculations e.g. i want to replicate the table i would have in the query but in terms of measures.
Hello @Ireland111,
1. Create a measure that captures the slicer value:
Slicer Value = SELECTEDVALUE('Table'[SlicerColumn])
2. Create measures that use the slicer value to perform calculations:
Calculation = 1000 * [Slicer Value]
3. Use the calculated measures to perform subsequent calculations:
Final Calculation = [Calculation] + 500
Keep in mind that measures are calculated at runtime based on the context of the visuals they are used in. Therefore, as you change the slicer selection, the measures will automatically recalculate and update accordingly.
Note: Alternatively, you can also use calculated columns instead of measures if you need the dynamic calculation to be part of the data model itself rather than being calculated on the fly.
Let me know if you might need further assistance.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |