Forum Discussion

tkerr198's avatar
tkerr198
Frequent Visitor
8 months ago
Solved

Conditional Formatting on a Matrix & More

I've been stuck on a problem for my work for a while. I've made progress, but I can't seem to find a prooper solution to my conditional formatting issue.   In Microsoft Power BI, I want to setup a ...
DAX
Dax Help
Need Help
need Help with measure
Report Server
  • v-dineshya's avatar
    v-dineshya
    8 months ago

    Hi tkerr198 ,

    Please refer below steps.

     

    1. Created Disconnected table.

     

    VersionTable =
    ADDCOLUMNS (
    GENERATESERIES(
    MIN(DataPage_Tables_Append1[Version]),
    MAX(DataPage_Tables_Append1[Version]),
    1
    ),
    "Version", [Value]
    )

     

    2.  Please refer below , updated DAX measures.

     

    VAR _NextVersion =
    CALCULATE (
    MIN ( VersionTable[Version] ),
    VersionTable[Version] > _Version
    )

     

    VAR _PrevVersion =
    CALCULATE (
    MAX ( VersionTable[Version] ),
    VersionTable[Version] < _Version
    )

     

    3.  In Matrix visual,  Rows --> DocNum,  Columns --> VersionTable[Version] and 

    Values --> Document Status.

     

    Please refer below output snaps. and attached PBIX file.

     

     

    If you still facing the same issue. Please provide sample pbix file and provide sample output snap, and please provide more information regarding your query, it will help us to replicate the scenario. Do not include sensitive information. 

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

     

tkerr198's avatar
tkerr198
Frequent Visitor
8 months ago

Hello,

Thank you for your repsonse! I tried this solution out, but I am somehow running into problems with it.

 

Reopened is appearing randomly in my matrix, when the DocNum has not been closed between Versions. Also, almost all versions at the end of the matrix still show as Closed.

 

Is there something that I am possibly missing?

v-dineshya's avatar
v-dineshya
Community Support
8 months ago

Hi tkerr198 ,

Please refer below steps.

 

1. Created Disconnected table.

 

VersionTable =
ADDCOLUMNS (
GENERATESERIES(
MIN(DataPage_Tables_Append1[Version]),
MAX(DataPage_Tables_Append1[Version]),
1
),
"Version", [Value]
)

 

2.  Please refer below , updated DAX measures.

 

VAR _NextVersion =
CALCULATE (
MIN ( VersionTable[Version] ),
VersionTable[Version] > _Version
)

 

VAR _PrevVersion =
CALCULATE (
MAX ( VersionTable[Version] ),
VersionTable[Version] < _Version
)

 

3.  In Matrix visual,  Rows --> DocNum,  Columns --> VersionTable[Version] and 

Values --> Document Status.

 

Please refer below output snaps. and attached PBIX file.

 

 

If you still facing the same issue. Please provide sample pbix file and provide sample output snap, and please provide more information regarding your query, it will help us to replicate the scenario. Do not include sensitive information. 

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

 

 

  • v-dineshya's avatar
    v-dineshya
    Community Support
    8 months ago

    Hi @tkerr198 ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

     

    Regards,

    Dinesh