Skip to main content
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

Resolver I
Resolver I

Selected value table

Hello can anyone please help me?

I have the following table visual which I intend to sit as shown below -

The data from this comes from at table structured like as below. (More headings than KSI and VTI this is demo and demo data)


Reporting MonthRegionKSIVTI
Jun-23North West34454
Jun-23South East7665
Jun-23South West3456


As I want my data to look like the below in the table I have so far created a bridging table of sorts as I needed the data from my original table named Data feed and the headings in the order I wanted them.


And a variable

KSI 1 =
VAR selectedcategory=ALLSELECTED('Data feed'[Region])
CALCULATE([KSI Total],FILTER('Data feed','Data feed'[Region]=selectedcategory))



Now this all works including the slicers apart from the issue is I need the value in the KSI 1 for example to be blank when it is not that Metric and not repeated. I have 2 slicers on the page reporting date and Region both come from from the Data feed table. Can anyone help??


Resolver I
Resolver I

Thanks @lbendlin for reply


So my table called Data feed bridging table looks like this -

So I want to be able to slice my table by region and date (Only been able to include one month).

But at the moment its working fine but the values are repeating on each metric as above picture in first post when I only want them to show in the measure in the column and if not blank.


Metric numberMeasure groupsMetricWeighting
2FINLost Time Injury (LTI)10.00%
4RTN% cleared within 1 hr10.00%
5ComplaintsRoadworks information2.50%
5Corporate CarbonComplaints2.50%
6Biodiversity Units addedCorporate Carbon5.00%


This is the data feed table

Reporting MonthRegionVTIFINLESSRTNCorrespondenceBELLComplaintsCorporate Carbon
01/06/2023North West100000.260.7600.90335434
01/06/2023South East15800.070.6900.79700
01/06/2023South West13100.260.800.786450

Please include all required details - what is your calendar table looking like, and what is your expected outcome?

Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to

Please show the expected outcome based on the sample data you provided.

Want faster answers?

Helpful resources

Europe Fabric Conference

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.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors