Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
11 months ago
Solved

Default value on Visual Card

Hi good day can anyone help me on my visual card default value, i have slicer Bridge with  A,B and C on the selection, if non selected on the slicer Bridge i want a default value from POB PLAN&ACTUAL, my card value are come from POB PLAN and POB ACTUAL. Each table has a current week column.

Thank you

  • Hey AllanBerces ,

    You can use nested SELECTEDVALUE, or some SWITCH, IFs:

    BridgePick =
    SELECTEDVALUE ( 'Bridge'[Bridge],
        SELECTEDVALUE ( 'POB_PLAN&ACTUAL'[Bridge],
            "Default"
        )
    )
    

     

    SELECTEDVALUE is great here, because if there's more than value for particular column, it's gonna return BLANK, therefore calling fallback value.

  • Hi AllanBerces 

     

    I believe this could be done by checking if any value is selected in the slicer

     

    We can have a measure for that such as:

    IsBridgeSelected = 
    IF(
        ISFILTERED(Bridge[BridgeColumn]), // Replace BridgeColumn by your actual bridge key/column
        1,
        0
    )

     

    Then accordingly we can create the measure to be used within the table

    CardValue = 
    IF(
        [IsBridgeSelected] = 1,
        CALCULATE(
            SUM(POB_PLAN[Value]),
            POB_PLAN[Week] = [CurrentWeek] 
        ),
        CALCULATE(
            SUM(POB_PLAN&ACTUAL[Value]),
            POB_PLAN&ACTUAL[Week] = [CurrentWeek] 
        )
    )

     

    Adjust the actual column names based on the desired measures, you could also have the selected value as a variable to check if the anything is selected within the slicer and then use the measure within the card visual. Please provide more context if this doesnt help.

  • Use a measure like this:

     

    Card Value =
    VAR Sel = SELECTEDVALUE(Bridge[Bridge])
    RETURN
    IF (
    ISBLANK(Sel),
    CALCULATE([Your Measure], ALL(Bridge), POB_PLANACTUAL),
    [Your Measure]
    )


    If slicer has A/B/C → show that.
    If slicer is blank → default to POB_PLANACTUAL.

7 Replies

  • Hey AllanBerces ,

    You can use nested SELECTEDVALUE, or some SWITCH, IFs:

    BridgePick =
    SELECTEDVALUE ( 'Bridge'[Bridge],
        SELECTEDVALUE ( 'POB_PLAN&ACTUAL'[Bridge],
            "Default"
        )
    )
    

     

    SELECTEDVALUE is great here, because if there's more than value for particular column, it's gonna return BLANK, therefore calling fallback value.

  • Hi AllanBerces 

     

    I believe this could be done by checking if any value is selected in the slicer

     

    We can have a measure for that such as:

    IsBridgeSelected = 
    IF(
        ISFILTERED(Bridge[BridgeColumn]), // Replace BridgeColumn by your actual bridge key/column
        1,
        0
    )

     

    Then accordingly we can create the measure to be used within the table

    CardValue = 
    IF(
        [IsBridgeSelected] = 1,
        CALCULATE(
            SUM(POB_PLAN[Value]),
            POB_PLAN[Week] = [CurrentWeek] 
        ),
        CALCULATE(
            SUM(POB_PLAN&ACTUAL[Value]),
            POB_PLAN&ACTUAL[Week] = [CurrentWeek] 
        )
    )

     

    Adjust the actual column names based on the desired measures, you could also have the selected value as a variable to check if the anything is selected within the slicer and then use the measure within the card visual. Please provide more context if this doesnt help.

  • Shahid12523's avatar
    Shahid12523
    Community Champion

    Use a measure like this:

     

    Card Value =
    VAR Sel = SELECTEDVALUE(Bridge[Bridge])
    RETURN
    IF (
    ISBLANK(Sel),
    CALCULATE([Your Measure], ALL(Bridge), POB_PLANACTUAL),
    [Your Measure]
    )


    If slicer has A/B/C → show that.
    If slicer is blank → default to POB_PLANACTUAL.

  • v-venuppu's avatar
    v-venuppu
    Community Support

    Hi AllanBerces ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Shahid12523 MohamedFowzan1 vojtechsima FBergamaschi  for the prompt response.

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.

  • Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

     

    Need help uploading data? click here

     

    Want faster answers? click here

  • v-venuppu's avatar
    v-venuppu
    Community Support

    Hi AllanBerces ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Community Support

    Hi AllanBerces ,

    I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

    Thank you.