Forum Discussion

Tasos's avatar
Tasos
Helper II
7 years ago

Dynamic summarize

Hello,   A question that can either be really easy to answer or too difficult.   I have a database with Orders; Order numbers, product code, date, quantity sold and various other flags (country, ...
Need Help
Tips and Tricks
Chihiro's avatar
Chihiro
Solution Sage
7 years ago

Oh, I get it now, I misunderstood your question orignally.

 

To clarify, what you want is dynamic histogram, based on slicer selection?

 

This isn't possible through conventional means that I can think of.

Since DAX tables and calculated columns are calculated when the model is first processed, and will not update with slicer selection.

 

Are you ok with using R-Visual with script?

 

There may be way to do it in DAX, but I'll have to think on it a bit.

 

Tasos's avatar
Tasos
Helper II
7 years ago

Chihiro,

 

Yes. Now you have really understood my problem.

 

I agree with you, columns are based on the total values and not the page slicers.

 

I haven't tried the R-visual before. If you can do it, then I can just copy your solution to my file.

 

In any case, I appreciate your help!