Видео

@@happyimhealthy thanks

@@mohitjangid4807 thanks.. you can check this video for adding total in. bar char chart ruclips.net/video/Aar-r2VO98M/видео.htmlsi=gyBZ0XqQRZgfcpto

thanks for the feedback, video uploaded post this i have tried to be as slow as possible

I agree, it can be broken into smaller one also and call different measures

thanks

Hi @Bangloreblogs i guess i missed the max limit to set at 1.001. so it take less than value not equal to value while creating parameters so when you setting range please give max value something thing like 1.01 it should so when in slider you slide to max it 1 will be selected Apologies for inconvenience, i have added the explanation as well in my description

@@Howtosolveprobem thanks boss🥰🥰

please reach out me on my instagram page..

ideally it should have

Yeah, options drop down is not there

this option was changed, Select "Tabular" layout under "Layout and style presets".

thanks

@@RANJITHKUMAR-yp6lg hope this helps

Thanks

Welcome 😊

Hi madhu, i have used sales super store data and i have mentioned in video at 2.24 min

@@boluwatifeq2961 thanks feedback

thank

Thanks

So whenever on the x-axis, if it is sales for a given region then how much is each category contributing is (for example office supplies ) calculate the sales for office supplies

Hi Uday, thanks for the feedback, ideally it should sort even if has more than 10 values if sorting is in increasing or decreasing order but if your expectation is to have a custom sort then yes you first need to create a custom sequence and then sort but that sequence is my understanding of your question is correct if not please provide more context

@@Howtosolveprobem HI, i tried and i found the same problem. The reason is, when the sub categories have more than 10 values, the category will be split into 2 groups in the chart. Since the 'Rank Order Value' is '1xx', it is bigger than other categories' rank order value, like 31,32,41,42..... Do you have any suggestion for this case? Thank you in advance.

thanks… sure working on it

Thanks for support and feedback

when you say state level remain unchanged meaning?? cab you please elaborate??

thanks

@@vinodjadhav7334 i use zoom call for recording

​@@HowtosolveprobemThank you bro😊

are you getting all regions + total in the temp table you created? if not then that would be the first reason. Second, do you know if the connection was made correctly? coz this is a simple data base. else it will be difficult to say without looking into the data

@@Howtosolveprobem connection was the issue, I fixed it. One more thing is it possible to not change the value of single bar in the chart even when slicer/filter is applied?

can you please elaborate, if my understanding is correct if you apply filter/slicer then it should not impact your visual? of not can you please elaborate

@@Howtosolveprobem yes even if filter is applied total value should not be changed

@@SanjeethaGowda yes very much possible, go to fomrat then edit interactions, so which ever visual you want to disconnect apply that n good to go.. hope this solves the problem

Thank you! Cheers!

Hi could you please elaborate??

sure…

thanks for your feedback.. in my recent videosi tried to be slow as possible

@@eduardorommeocastulolopez4814 Hi there is one work around is you can create how hide button instead of slicer if you have only two fields where you need to toggle it can be achieved by creating two charts second option that i tried using summarise funtion where i am able to achive the chart using slicer change but here the challenge is to make relationship btw parent table and summarize table if i am able to establish relationship btw parent n sumary table then it is doable

thanks!!! when you say slicer? is that date then definitely it will work n based on range of selected date max n min will be calculated reason being if you see we have made connection so if my primary table gets filter then it should he reflected on my other table as well

thanks

Thanks for liking

thank

drive.google.com/file/d/1_9EGV82deHQKO_6aS6VCVwpsxr0ueDJN/view?usp=drive_link

Glad it was helpful!

so you if have su. category slicer instead of category then process remains same, is that you answer or if you have something other thoughts (please explain)

@@Howtosolveprobem I have category and if I select category that excluding after seeing your video. For example India is a category and states is sub category and if same India states assigned to other countries if I select India apart from names with India states I want to display other country states that means if selected country names repeated for other countries that should exclude. It could be grearful if you could provide solution for this I am stuck with this since a week. Thanks in advance

Hi could you please check above comment it could be grearful if you provide me suggestion

Hi, its a good question so here we need to take category which has multiple value and i need to take each row in context and this is specifically with measure we need to have aggregate. If you try without max it will throw an error so by using max it will go to each value and check if it exist in given list if yes then it will return 1 else zero hope i am able to resolve query if not please do reach out me i will try solve by taking some examples

Thanks

Glad it helped

at what is the error and, it can be multiple reasons can you please highlight your issue

sure definitely 👍 will keep that in mind

I have added my instagram id in description please do check

thanks✌🏻

this is open source sale super store data which can be downloaded easily or you can download from this data.world/missdataviz/superstore-2021

thanks for your valuable feedback

Glad it helped

Sure, thanks for video suggestions. Will make video on that

i did explore that but it did not have option to format and neither with dax, but i am open to explore more on this