Forum Discussion

Goonj's avatar
Goonj
New Member
6 months ago
Solved

2 Dimensional Data

Dear All, I am trying to create a visual which can show 2 Dimensional Data.

 

For example i wish to show RAG (Required, Available and Gap)

 

Lets say i use a matrix table , i have created measures for Required - Available - Gap and all columns. 

 

is there any other visual i can use so my stakeholders can get a good view of open positions as per below requirement 

 

department wise - role wise numbers 

 

 

  • Hi Goonj,

    matrix looks the right choice, if you do not want to drill down/see subtotals but want to see all the values of all the columns in all the rows, you can coinsider a table visual

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

  • The closest visual to that is a matrix which layout is either tabular or compact

     

4 Replies

  • Hi Goonj,

    matrix looks the right choice, if you do not want to drill down/see subtotals but want to see all the values of all the columns in all the rows, you can coinsider a table visual

     

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

  • The closest visual to that is a matrix which layout is either tabular or compact

     

  • Thankyou, FBergamaschi and danextian for your responses.

    Hi Goonj,

    We appreciate your inquiry through the Microsoft Fabric Community Forum.

    We would like to inquire whether have you got the chance to check the solutions provided by FBergamaschi and danextian to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

    Thank you.

  • Hi Goonj,

    We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

    Thank you.