2 Dimensional Data

[Goonj]

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 

[FBergamaschi · Accepted solution]

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

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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.

[danextian · Accepted solution]

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

[FBergamaschi · Accepted solution]

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