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 All,
I created metrics selection using the below link, where i have 4 metrics and report is changing after metrics selection. This is working fine for me.
I am trying to add further steps in this, where for each metrcis type have 6-7 metrics(like MAT, YTD etc). I want to display 7-8 metrics togeather in report whenever i select metrics1, same way if i select metrics2 then display another set of 7-8 metrics.
https://1drv.ms/u/s!AtDlC2rep7a-jkiRG_LyHcv0RSXI
Can you please help me how to achive this?
Thanks
Krishna
Hi @kthakur,
One workaround is to wrap each measure with a IF condition, and add each measure into visual. That is to say, if you have four measure type, each of them has 6 measures, then, you need to add 24 measures into visual.
Measure1_1 = IF(SELECTEDVALUE(Table1[MeasureType])="Measure1",SUM(Table2[Val]),BLANK()) Measure1_2 = IF(SELECTEDVALUE(Table1[MeasureType])="Measure1",COUNT(Table2[Val]),BLANK()) Measure2 = IF(SELECTEDVALUE(Table1[MeasureType])="Measure2",AVERAGE(Table2[Val]),BLANK())
Result in my test.
Best regards,
Yuliana Gu
Hi v-yulgu-msft,
Thank you for your response, your solution is looking good to me but i have some confusion that where are you doing the below calculation.
If possible, can you please share the pbix file?
Thanks
Krishna
Hi Yuliana Gu,
I am able to replicate the metrics selection as per your example.
I have one small problem in that, your example show line chart where other metrics (unselected) are not visible but in my scenario I have table where it shows that measure2 as blank if measure1 is selected.
Can you please suggest how can i hide the mesaure if other metrics are selected?
Thanks
Krishna
Hi @kthakur,
Add multiple measures in a table visual, the values under each measure can be visible/invisible dynamically based on slicer selection. However, the column headers which are measure names here cannot be hided. Currently, it is not supported to hide column name or measure names conditionally.
Regards,
Yuliana Gu
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 |
---|---|
68 | |
60 | |
51 | |
36 | |
35 |
User | Count |
---|---|
84 | |
71 | |
56 | |
45 | |
43 |