Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am currently working on creating a visual that has the same indentation structure and appearance as the Excel table below. Unfortunately, achieving this with the standard table or matrix visual in Power BI is not possible as far as I know.
Note: the values in de columns are measures from different tables.
Thanks in advance!
Solved! Go to Solution.
Hi @thomma
You can acheive it, but it will take some modelling and creating measures.
Contracted Projects =
CALCULATE(
DISTINCTCOUNT('Project'[ID]),
KEEPFILTERS ('Project'[Type] = "Contracted")
Repeat the measures for each row then create this measure
Matrix View =
SWITCH (
SELECTEDVALUE ( 'Project Matrix'[LineItem Desc] ),
"Contracted projects", [Contracted Projects],
"Already invoiced", [Already Invoiced],
"To Invoice", [To Invoice],
"Prospects (100%)", [Prospects - 100%),
"Prospects (75%)", [Prospects - 100%),
"Total prospects", [Total Prospects],
"Estimated Revenue", [Estimated Revenue])
This will show everything in one row, to acheive what you have in the Screenshot, you will need to create two further measures in the same format, but remove To invoice, total prospects and estimated revenue from the first emasure. In the second measure, just add To invoice, total prospects and in the thrird measure just add Estimated Revenue
Make sure that the Text in the measure matches that of your generated table
Thanks
Joe
If you found my answer helpful and it solved your issue, please accept as solution
it is possible if you use proper dax for every column, usinng functions like ALL, ALLExcept, Filter, calculate , you can achieve this, pretty easy if you know the filter conditions properly.
Hello @thomma ,
You can use ROW function to combine multiple measure and make a single table using UNION overall syntax looks as below:
Firstly Go to modelling in Power BI Desktop and click on New Table
Then give some name for table and its DAX calculation should look as below:
Table_Name =
Union(
ROW(.........................................................),
ROW(.........................................................),
)
You can use this in a Matrix visual.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hi @thomma
You can acheive it, but it will take some modelling and creating measures.
Contracted Projects =
CALCULATE(
DISTINCTCOUNT('Project'[ID]),
KEEPFILTERS ('Project'[Type] = "Contracted")
Repeat the measures for each row then create this measure
Matrix View =
SWITCH (
SELECTEDVALUE ( 'Project Matrix'[LineItem Desc] ),
"Contracted projects", [Contracted Projects],
"Already invoiced", [Already Invoiced],
"To Invoice", [To Invoice],
"Prospects (100%)", [Prospects - 100%),
"Prospects (75%)", [Prospects - 100%),
"Total prospects", [Total Prospects],
"Estimated Revenue", [Estimated Revenue])
This will show everything in one row, to acheive what you have in the Screenshot, you will need to create two further measures in the same format, but remove To invoice, total prospects and estimated revenue from the first emasure. In the second measure, just add To invoice, total prospects and in the thrird measure just add Estimated Revenue
Make sure that the Text in the measure matches that of your generated table
Thanks
Joe
If you found my answer helpful and it solved your issue, please accept as solution
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |