Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Community!!
I need help regarding creating a table in a dashboard such that the Measures I have created can be seen row-wise and measures like past 7 days, past 14 days and past 21 days would be column-wise. Kindly see a screenshot that I have attached.
(I have made all the measures which are shown below for 7days,14days,21 days)
Solved! Go to Solution.
@pmusram , So you want to measure to dimension conversion ?
This means these split for measures. In that case, you need to create a table like one given below and use that
union(
summarize('Table',"Measure","App","Last 7 Days",[APP 7 Day],"Last 14 days",[APP 14 days],"last 21 Days",[APP 21 Days])
summarize('Table',"Measure","App","Last 7 Days",[Leads 7 Day],"Last 14 days",[Leads 14 days],"last 21 Days",[Leads 21 Days])
)
@pmusram , So you want to measure to dimension conversion ?
This means these split for measures. In that case, you need to create a table like one given below and use that
union(
summarize('Table',"Measure","App","Last 7 Days",[APP 7 Day],"Last 14 days",[APP 14 days],"last 21 Days",[APP 21 Days])
summarize('Table',"Measure","App","Last 7 Days",[Leads 7 Day],"Last 14 days",[Leads 14 days],"last 21 Days",[Leads 21 Days])
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |