Forum Discussion
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 Month | Region | KSI | VTI |
| Jun-23 | East | 45 | 545 |
| Jun-23 | Midlands | 3479 | 454 |
| Jun-23 | North West | 34 | 454 |
| Jun-23 | South East | 76 | 65 |
| Jun-23 | YNE | 45 | 56 |
| Jun-23 | South West | 34 | 56 |
| Jun-23 | National | 2445 | 45 |
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
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
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-Forum/ba-p/963216
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/1447523Thanks 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 number Measure groups Metric Weighting 1 VTI KSI 10.00% 2 FIN Lost Time Injury (LTI) 10.00% 3 LESS LTI 10.00% 4 RTN % cleared within 1 hr 10.00% 5 Correspondence SRUS 2.50% 5 BELL Correspondence 2.50% 5 Complaints Roadworks information 2.50% 5 Corporate Carbon Complaints 2.50% 6 Biodiversity Units added Corporate Carbon 5.00% This is the data feed table
Reporting Month Region VTI FIN LESS RTN Correspondence BELL Complaints Corporate Carbon 01/06/2023 East 241 0 0.56 0.72 0 0.902 34 34 01/06/2023 Midlands 219 0 0.16 0.73 0 0.7 0 0 01/06/2023 North West 1000 0 0.26 0.76 0 0.903 354 34 01/06/2023 South East 158 0 0.07 0.69 0 0.797 0 0 01/06/2023 YNE 413 0 0.28 0.77 0 0.999 0 0 01/06/2023 South West 131 0 0.26 0.8 0 0.786 45 0 01/06/2023 National 126 0 0.3 0.89 0 0.701 0 44 Please include all required details - what is your calendar table looking like, and what is your expected outcome?
