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
jaltoft
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-23East45545
Jun-23Midlands3479454
Jun-23North West34454
Jun-23South East7665
Jun-23YNE4556
Jun-23South West3456
Jun-23National244545

 

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.

jaltoft_3-1706798607477.png

And a variable

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

 

jaltoft_2-1706797847147.png

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??

 

3 REPLIES 3
jaltoft
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
1VTIKSI10.00%
2FINLost Time Injury (LTI)10.00%
3LESSLTI10.00%
4RTN% cleared within 1 hr10.00%
5CorrespondenceSRUS2.50%
5BELLCorrespondence2.50%
5ComplaintsRoadworks information2.50%
5Corporate CarbonComplaints2.50%
6Biodiversity Units addedCorporate Carbon5.00%

 

This is the data feed table

Reporting MonthRegionVTIFINLESSRTNCorrespondenceBELLComplaintsCorporate Carbon
01/06/2023East24100.560.7200.9023434
01/06/2023Midlands21900.160.7300.700
01/06/2023North West100000.260.7600.90335434
01/06/2023South East15800.070.6900.79700
01/06/2023YNE41300.280.7700.99900
01/06/2023South West13100.260.800.786450
01/06/2023National12600.30.8900.701044

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

lbendlin
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 https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
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.

PBI_Carousel_NL_June

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