The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
is it possible to place measures in table/matrix as below in Power BI? Basically I know how to create all the measures, but I don't know how to allocate them in presented way. Many Thanks, Kamil
to format calculation groups select in Property Format String Expression
@Anonymous , You have create a custom table or calculation groups
example
union(
summarize('Table',"Measure","Min","Test1",min('Table'[Test1]),"Test2",min('Table'[Test2]),"Test3",min('Table'[Test3]))
summarize('Table',"Measure","Max","Test1",max('Table'[Test1]),"Test2",max('Table'[Test2]),"Test3",max('Table'[Test3]))
)
"QTD" , "YTD" , "MTD"
union(
summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
)
But new table will not take filters so you need to add them as a group by in the new table and join them with dimensions again
tabular - Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations
Hi @amitchandak ,
Thank you for support, you are very helpful as always 🙂 I used calculation group in order to create desired table. I approached next challange - I wanted to apply conditional formatting for 2 out of 6 calculated items. Is there any possibility for this? Thanks, Kamil
User | Count |
---|---|
83 | |
83 | |
34 | |
32 | |
32 |
User | Count |
---|---|
94 | |
79 | |
62 | |
54 | |
51 |