Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kthakur
Helper I
Helper I

Displaying set of metrics on selection

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

4 REPLIES 4
v-yulgu-msft
Employee
Employee

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.

1.PNG2.PNG3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi v-yulgu-msft,

 

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.