Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to replace values at dashboard level?

Hello!   Some questions please:   1) I have joined several tables using a common column. However, then I put columns from these tables together, there are some empty cells that appear in the join...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    1) This is determined by the table relationship. I made an example:

    My data model:

    My visualization:

    Maybe your data model is different from mine, but the principle is the same.

     

    2) First, the dashboard is a concept in Power BI Service, while DAX can only be used in Power BI Desktop. 

    For your problem, you can try to create a measure like this:

    Measure = 
IF(
    MAX(Table2[Public ]) = BLANK() && MAX(Table1[Index]) <> BLANK(),
    "YES",
    MAX(Table2[Public ])
)

     

    Best regards,
    Lionel Chen

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

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

1) This is determined by the table relationship. I made an example:

My data model:

My visualization:

Maybe your data model is different from mine, but the principle is the same.

 

2) First, the dashboard is a concept in Power BI Service, while DAX can only be used in Power BI Desktop. 

For your problem, you can try to create a measure like this:

Measure = 
IF(
    MAX(Table2[Public ]) = BLANK() && MAX(Table1[Index]) <> BLANK(),
    "YES",
    MAX(Table2[Public ])
)

 

Best regards,
Lionel Chen

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