Forum Discussion
Can't show date in visual level (Report level)
Hi all,
I hope someone can help me find a solution or advise me on how i need to change data tables, to be able to show needed data for end users.
I have a table1 with row data:
| featureID | featureName | Version |
| t-1 | name1 | 0.1 |
| t-2 | name2 | 0.2 |
| t-3 | name3 | 0.1 |
I have a table2 with row data:
| ID | StartDate | StopDate |
| 0.1 | 1.1.2019 | 1.3.2019 |
| 0.2 | 2.3.2019 | 1.6.2019 |
| 0.3 | 2.6.2019 | 7.9.2019 |
Relation: Table1(Version) - Table2 (ID).
I have a table3 with calculated info. Data is calculated by filtering table1 and by using date from table2.
| Version | KPI1 | KPI2 | KPI3 |
| 0.1 | 4 | 5 | 1 |
| 0.2 | 2 | 1 | 3 |
I also have reports (diagrams) - Line chart and Table (table name is KPI table) to show information from the table2.
Now i only need to find a way to show IDs (from the table1) that are calculated to e.g. value 2 (value from table 3 KPI1) in the table under Reports (visual part). Right now my table shows all IDs from table 1, even i have selected 2 in the KPI table.
Thank you in advence! Really appreciate all help.
3 Replies
Hi,
I the visual level i have:
- table with columns: versionID,KPI1, KPI2, KPI3.
- table with featureID, name.
What i what is when i select value from the first table, i would have a list of features that were calculated in this selected value.
So when user clicks on 1 (0.2+KPI2), the second table list of all features should show only one feature that is calculated in the value 1.
Version KPI1 KPI2 KPI3 0.1 4 5 1 0.2 2 1 3 calculated in the value 1.
Feature ID Feature Name t-2 name2 br,Natalia
Maybe the problem in my calculation?
I also have a colum that calculates total amount - Total=count(Table1[featureID]). When i click on Total, i have a list of alla issues that are calculated into this value.
But other calulations are more complex, like:
M_PlannedDone = CALCULATE(COUNT('Table1'[featureID]); filter('Table1'; 'Table1'[type] in {"New"; "CR"} && 'Table1'[Closed date] >='Table1'[PI_start] && 'Table1'[Closed date]<='Table1'[PI_stop] && 'Table1'[Splitted]=1))Calculated value is correct, but when i click on the value i have a list of all issues from the table1.