Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have two graphs (two tables) referred to the sales of an online shop: a table is referred to the sales in the north of a country, while the second to the south. The dimension of each table is the category of the sale (shoes, phones, food, etc.), while i have several expressions to count numeric expressions of the sales (current month, previous month, delta, etc.).
The issue is the following: when selecting a category from a table, i want that the same category is selected and showed also in the other table. Unfortunately, this happens only when, in the other table, the same category has, at least, a measure not null. I want that also in this case (all the measure null), the value of the category selected is showed in the other table. I also tried to flag checkboxes in the properties table (show null values, show missing values) but it does not work.
Any suggestions?