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,
I have this table:
What i want to do (if it´s possible) is to change the column that i use as a target of the gauge depending of the year i select in a timeline slicer : If i choose a single year (like 2017) it has to look for the value from the column "Programado", and if i choose all the years (in this example 2016, 2017 and 2018) it has look for the value from the column "Programado hoy".
Thank you for the attention (and excuse me for my limited knowledge of english).
Solved! Go to Solution.
Hi @JuanVillabona,
We can not dynamically change the column added to target value of Gauge. But you can create a measure which is dynamically changed based on slicer selection, add this measure to Target Value.
That case, you should create an unrelated extra table (suppose it's named as 'SlicerTable') which lists all available slicer items, like 2016, 2017, 2018 and so on. Add this column to slicer.
Then, the measure formula is similar to:
TargetVal=IF(MAX('SlicerTable'[YearNo])=2017, SUM('SourceTable'[Programado]), SUM('SourceTable'[Programado hoy]) )
Reference:
Dynamic Measure Selection in Power BI
Best regards,
Yuliana Gu
Hi @JuanVillabona,
We can not dynamically change the column added to target value of Gauge. But you can create a measure which is dynamically changed based on slicer selection, add this measure to Target Value.
That case, you should create an unrelated extra table (suppose it's named as 'SlicerTable') which lists all available slicer items, like 2016, 2017, 2018 and so on. Add this column to slicer.
Then, the measure formula is similar to:
TargetVal=IF(MAX('SlicerTable'[YearNo])=2017, SUM('SourceTable'[Programado]), SUM('SourceTable'[Programado hoy]) )
Reference:
Dynamic Measure Selection in Power BI
Best regards,
Yuliana Gu
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |