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
Tasos's avatar
Tasos
Helper II
7 years ago

Chihiro parry2kLivioLanzo

 

I have been trying to understand how Chihiro's suggestion could answer my question and I fail to do that. 

 

Could you please use the example and make a high-level example of what you meant?

 

Thanks,

Tasos

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!