Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I'm struggling with a problem which seems so simple to achieve but seems impossible in PBI.
I have a column with multiple rows with different values in them
Col1
1.01
1.03
1.04
1.05
In my report I have a slicer with values of
£100
£200
£300 etc.
I want to use the value in the slicer to create a value either in a measure or in a column, the problem is the value selected is on the report and can be different each time.
What I effectively want to do is
Measure = ValueSelected*([col1]-1)
So the measure on the page would be
100 * (1.01-1)
100 * (1.02-1)
If the user select 200 the measure would be
200*(1.01-1)
200*(1.02-1)
ETc., the 100 and 200 being the figures selected in the slicer the 1.01, 1.02 are the values of the rows in the column
Any ideas
Solved! Go to Solution.
First of all you can't use a column for this, because columns are calculated during refresh. Has to be a measure.
- The table with 100, 200 and so on must be disconnected (= no relationship).
- Get the current selected value from the disconnected table
- Apply it to your measure, for example:
YourFinalMeasure =
VAR RowValue = SELECTEDVALUE(YourTable[Col1])
VAR SelectedBase = SELECTEDVALUE(DisconnectedTable[Value])
RETURN (RowValue-1) * SelectedBase
Wow that worked a treat. Thank you so much!
It is a measure I'm trying to create, thank you for replying however I don't think this will work as I only have one SELECTED Value the other is a row in a column.
WIll let you know thanks again.
First of all you can't use a column for this, because columns are calculated during refresh. Has to be a measure.
- The table with 100, 200 and so on must be disconnected (= no relationship).
- Get the current selected value from the disconnected table
- Apply it to your measure, for example:
YourFinalMeasure =
VAR RowValue = SELECTEDVALUE(YourTable[Col1])
VAR SelectedBase = SELECTEDVALUE(DisconnectedTable[Value])
RETURN (RowValue-1) * SelectedBase
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
62 | |
58 | |
55 | |
36 | |
33 |
User | Count |
---|---|
81 | |
67 | |
45 | |
45 | |
43 |