Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Default Value from mensure to use Gauge

Hi Guys.
Using powerbi here I try some crazy ideas but I never find a reference, I search and search and I can't find a solution.
Thank you for your help.


I want the Gauge with reference to a row, but the value comes from a measure. I couldn't use SELECTVALUE for this.


This is because in the model I have in mind, the value of the reference line is not the sum of all results. It's percentage of completion. That is, if you click on another row, the gauge will change, but without any selection, it will keep the reference row.





Community Support
Community Support

Hi  @Peleias ,

When I hide the value of 0.5 using the filter next to it, the total will still be displayed.


If you want the same effect as the measure in Gauge, you can use:

Flag =



Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yangliu-msft , I'm still searching the



Comments selection =
IF (
    ISFILTERED ( CommentsTable[Department] ),
    SELECTEDVALUE ( CommentsTable[Comments] ),
        SELECTEDVALUE ( CommentsTable[Comments] ),
        FILTER (
            ALL ( CommentsTable[Department], CommentsTable[Comments] ),
            CommentsTable[Department] = "Investments"

Basically this is what I would like, but as I said above, my column is a measure.
Selectvalue doesn't work with measure.



Sorry @v-yangliu-msft, I think I didn't explain it right.
Follow the pbix similar to what I need. 


Percentages are based on measure with MS Project data, so max value does not apply as some activities reach 100% before the main line.


What do I need; If nothing is selected, the Gauge will show the value of the Internal Services line (in this case, 50%).



In case I hide the Internal Services line later in the table, but the value will remain in the Gauge.

And when I click on the lines, they will be displayed in the Gauge.


Thanks, as each answer helps me with another 10 different things in power bi.

Community Support
Community Support

Hi  @Peleias ,

According to the design of the power bi engine, in the table, the measure is calculated according to the context, and the value of this measure will definitely have a specified column to calculate it.

So we can select the column corresponding to this measure to perform Selectvalue.

For example, if we want to select measure=50%, we can select the corresponding column [Start]=2022-10-5


I created some data:


Here are the steps you can follow:

1. Create measure.

Measure_Prg =
Flag =

2. Result:

When selected


When not selected:



Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Solution Supplier
Solution Supplier

@Peleias  I prefer to go with SELECTEDVALUE for this problem. Here is my solution.


For the default value, I have used the MAX value.




Thanks @ghoshabhijeet

I don't think I explained it right either, sorry.

The column is a measurement. And usually the numerical value of the reference line reaches 100% last. Usually several lines reach 100% and finally the reference line reaches 100%.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.