Help me to get similar visual in Power B

[ashmitp869]

Hi ,

Help me to get similar visual like below in Power BI :

How can I fit both Course Start Date and Expiry Date in one measures.
I am using matrix but unable to achieve as user expectation.

Users expectation is like below

Course Start Date and Expiry Date (Green or Red or can be any color depending on the logic )at same space

Sample file
https://github.com/suvechha/samplepbi/blob/main/SkillMatrix_sample%20modify.pbix

Any suggestion please @v-xinc-msft 

@v-xuxinyi-msft 

@v-xul @v-xiaoql @v-xicai @Greg_Deckler @lbendlin @Ritaf1983 @bhanu_gautam @danextian 
Thanks

Thanks

[danextian]

Hi @ashmitp869 

Try this:

test = 
VAR _start =
    FORMAT ( MIN ( EmployeesSkill[Course Start Date] ), "m/dd/yyyy" )
VAR _end =
    "E " & FORMAT ( MIN ( EmployeesSkill[Expiry Date] ), "m/dd/yyyy" )
RETURN
    _start & UNICHAR ( 10 ) & _end

Note: conditional formatting cannot be applied partially within the same measure. If you want to format them separately, use two separate measures.You can move the values to rows as su ggested by @MattiaFratello 

[MattiaFratello · Accepted solution]

Hi @ashmitp869,

Select your visual -> Format -> Values -> Options -> Switch Values 

If I answered your question please mark it as a solution

[ashmitp869]

Hi @MattiaFratello 
Is there any way to show the values vertical 

Similar like below

[MattiaFratello]

Hi @ashmitp869, as far as I know vertical column headers are not a built-in feature.

You may check if there is a Custom Visual in the AppSource

If I answered your question please mark it as a solution