Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have the following case
Column 1 Column 2 Column 3
P1 X name1
P2 Y name2
P3 X name3
P3 X name4
P4 Z name5
i have created a measure to count the value of Xs
then I have created a chart Column1 on the X axis, and the value is the measure. Now if I create a table visual with Column 3 and i press on name 3, the graph interacts. However if I press on the P3 in chart visual, the Column 3 does not interact. Why?
Solved! Go to Solution.
Hey,
this sounds that the interactions are disabled. I creates a little table with you sample data, and if select "P3" from the column chart the table visual interacts as expected.
Here is the code for my measure that counts the X in column2
count X = CALCULATE( COUNTROWS('SimpleTable') ,'SimpleTable'[Column2] = "X" )
Can you check the interaction settings:
I would expect that the filter symbol is shown above your table visual as shown in the screenshot
Hope this helps
Regards
Tom
Hey,
this sounds that the interactions are disabled. I creates a little table with you sample data, and if select "P3" from the column chart the table visual interacts as expected.
Here is the code for my measure that counts the X in column2
count X = CALCULATE( COUNTROWS('SimpleTable') ,'SimpleTable'[Column2] = "X" )
Can you check the interaction settings:
I would expect that the filter symbol is shown above your table visual as shown in the screenshot
Hope this helps
Regards
Tom
Hey Tom!
it is not about the interactions, they are set correctly. I have attached 3 photos.
As you can see, when I press on Core, P5 is not highlighted.
And when I press on P4 on the chart, the Core doesn't dissapear from the table.
Hey,
can you please share how you defined your measure.
If you select something in your table the visual will interact, but you also have to use the same measure "Release Count" within your table visual, as you can see in my screenshot.
Using just the column stream is not sufficient.
Regards
Tom
Yep Yep! now it worked. But visually I dont really like it. That way the release count will appear twice, once in the chart, and once in the table. Not that appealing 😞
Is there any other way? or maybe can I hide these column from the table ?
As for the formula I tried your and I tried the 'Count'
To have a better understanding of this behaviour, take a look at Show Categories With No Data.
Hey,
here you find a little pbix file, look at the report page "Visual Interactions", I guess this is what you are looking for, but I have no idea what is different from your table model.
Regards
Tom
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |